[Bucardo-general] private key vs. unique index
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
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