Thomas F. O'Connell <tfo at sitening.com> writes:
> So does adding and populating that column when Slony does it require
> table locks? I was allowing it to be created in some of the tables I'm
> attempting to replicate, and I wasn't sure whether the number of
> tables or the populating was taking so long.

I haven't checked on what _precisely_ Slony does, when adding the
primary key, but it would presumably involve:

 a) Altering the table to add the new key field - brief table lock
 b) Updating the field to contain values - probably a long set of row locks
 c) Creating the unique index - a table lock that is held for quite a while

Some parts of the process are or can be cheap, but part c) certainly
isn't.
-- 
(reverse (concatenate 'string "ofni.sailifa.ac" "@" "enworbbc"))
<http://dev6.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)