[Bucardo-general] private key vs. unique index
Marc Farnum Rendino
mvgfr1 at gmail.com
Fri Apr 15 20:54:59 UTC 2011
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.
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