<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">>i suspect that what is happening is that they're getting an error<br>
>because
they try to insert a null in the PK (they have a lot of those,<br>
>while
the pk is a sequence of numbers they didn't use serial when<br>
>created
it) what they want to do now, i guess, is to create a new pk<br>
>that is a
serial and allow the old pk column to accept nulls so if<br>
>they send a
value or a null it's meaningless (actually that is what i<br>
>see in the
script they want to execute)...<br><br>
Well, if the "name" of the primary key will not change, then EXECUTE
SCRIPT would work. However, based on the latest information you
provided. You might want to consider:<br>
A. <a href="http://slony.info/documentation/stmtsetdroptable.html">SET
DROP
TABLE</a> on the table with the pkey change.<br>
B. Do a manual DDL to change the pkey on all nodes. (Hopefully not too
many)<br>
C. Create a new set with the table and then a MERGE SET to add the table
back into replication.<br>
<br>
Of course, another factor would be the size of the table and how long it
would take to re-subscribe.<br>
<br><font size="4"><span style="font-weight: bold; font-family: arial; color: rgb(0, 0, 255);"></span></font><font size="4"><span style="font-weight: bold; font-family: arial; color: rgb(0, 0, 255);">Melvin Davidson </span></font><br><br></td></tr></table><br>