[Bucardo-general] private key vs. unique index

[Marc Farnum Rendino]

Joshua -

Thanks for the warning.

If I understand correctly, I can rely on the unique index columns in
my tables being not null, however I do have a few tables to add a
unique index to - solely to support Bucardo replication via pushdelta
(vs. fullcopy).

So it's up to me how to add them - is it possible (not being a pg
expert yet) to define the column such that the unique key is
automatically added (and not null) as a row is created, regardless of
how the row is created (or by whom)?

Thanks,

Marc

On Fri, Apr 15, 2011 at 11:16 AM, Joshua Tolley <josh at endpoint.com> wrote:
> You might run into problems if you have NULL values in that unique key;
> primary keys also enforce a NOT NULL constraint.