[Bucardo-general] private key vs. unique index

Marc Farnum Rendino mvgfr1 at gmail.com
Fri Apr 15 20:54:59 UTC 2011

Josh -

Sounds good; 'preciate it.

I like the added little bit of flexibility with unique keys - though
without a clear need for it in this case, I'll go with the added
"safety" of private keys.

Thanks again,


On Fri, Apr 15, 2011 at 3:50 PM, Joshua Tolley <josh at endpoint.com> wrote:
> Primary keys are easier for some things to deal with, sometimes, because of
> the special extras Greg mentioned that mark them as primary keys; on the other
> hand, unique keys can be created and replaced without locking the table
> particularly. Sometimes that's useful. I'd recommend primary keys, myself,
> because it's a pretty standard principle of database design that every table
> should have a primary key.

More information about the Bucardo-general mailing list