-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 > My questions is this: how would I go about changing my function so > that all the triggers EXCEPT the Slony trigger would be disabled? > Any ideas? .. > PostgreSQL 7.4.19 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 This won't help you immediately, but you might want to look at the new enable replica replica trigger functionality added in 8.3 (thanks Jan!): http://www.postgresql.org/docs/current/static/sql-altertable.html Could be more ammo to get you off of that old 7.4 :) > I have failed to mention that we are disabling all the triggers on > a given table only done during a transaction; thus, it affects no > one else. Be careful: if you are directly manipulating the system tables, you still run the risk of problems as the system tables are not completely MVCC safe unless you lock them. - -- Greg Sabino Mullane greg@xxxxxxxxxxxx PGP Key: 0x14964AC8 200802211338 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iEYEAREDAAYFAke9xUQACgkQvJuQZxSWSsifbACffN6/ohNCwvkvZ10Uvamyg264 nckAnRarfpLgrZYkLe6Q/FSW+edC2hQC =9GqX -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
