[Bucardo-general] private key vs. unique index

Joshua Tolley josh at endpoint.com
Fri Apr 15 15:16:11 UTC 2011

On Fri, Apr 15, 2011 at 10:05:48AM -0400, Greg Sabino Mullane wrote:
> ...
> > 2) Bucardo keeps a table with the private key (only; not the whole
> > row) that needs to be replicated.
> > 
> > However, in the case where there's only a unique index instead of a
> > private key, does this create any potential problems, additional
> > overhead, etc.?
> Nope, no problems. Matter of fact, a primary key is really just a 
> unique index with some fancy attribs on it, as far as Postgres 
> is concerned.

You might run into problems if you have NULL values in that unique key;
primary keys also enforce a NOT NULL constraint.

Josh Tolley   josh at endpoint.com   801-987-0252
End Point Corporation  http://www.endpoint.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: Digital signature
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20110415/797fd810/attachment.bin 

More information about the Bucardo-general mailing list