Norman Yamada nyamada at millburncorp.com
Fri Jun 13 06:24:48 PDT 2008
Dear All:

Running slony 1.2.13; 4 slave nodes; master and 3 of the nodes running  
postgres 8.2.6; one slave node running 8.3.1

I have a replicated table that has a oninsert rule.

I'd like to drop the rule from the table. How do I do this? I thought  
I could use a EXECUTE SCRIPT command to push the rule drop to all  
nodes, but this failed with a FATAL error. (Yes, I do realize the  
target of the rule has been changed in the system catalog tables for  
all slave nodes; and so need to drop this rule through a slonik  
mechanism -- I just don't know what that mechanism is! --

Thanks --

Norman
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2431 bytes
Desc: not available
Url : http://lists.slony.info/pipermail/slony1-general/attachments/20080613/4691deb9/smime.bin


More information about the Slony1-general mailing list