Vivek Khera vivek
Mon Feb 13 09:42:41 PST 2006
On Feb 12, 2006, at 2:06 PM, Marc G. Fournier wrote:

> So, just to clarify before I do it, all tables that have 'just a  
> UNIQUE
> key', I'll still have to do 'ALTER TABLE <table> ADD PRIMARY KEY  
> ( field
> );' to so that Slony likes them?

As long as it is unique + NOT NULL column, it is equivalent to a PK.   
Just tell slony which index qualifies for this.  it will not  
automatically figure it out.





More information about the Slony1-general mailing list