[Bucardo-general] private key vs. unique index

Marc Farnum Rendino mvgfr1 at gmail.com
Fri Apr 15 15:56:48 UTC 2011

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)?



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.

More information about the Bucardo-general mailing list