Geoffrey Myers wrote:
> As I understand it, 'execute script' will cause the slony triggers to 
> be deleted and then re-added.  If my 'execute script' only touches one 
> table, are all the slony triggers on all tables deleted and re-added, 
> or is it only those tables affected by the 'execute script?'
>
The script has no way to communicate with slonik to say "I'm just 
touching table1 and table2", so there's no way to avoid the need to 
drop/re-add all of the triggers to all of the tables.

In version 2.0, the 8.3+ capability to alter trigger "modes" is used 
instead, so that the drop/re-add issue goes away.

-- 
output = reverse("ofni.sailifa.ac" "@" "enworbbc")
<http://dba2.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)
"Bother,"  said Pooh,  "Eeyore, ready  two photon  torpedoes  and lock
phasers on the Heffalump, Piglet, meet me in transporter room three"