hi all,
I'm looking for a way to temporary disable a rule on a
table.
I've find (looking at the dump) the way to disable
triggers :
UPDATE "pg_class" SET "reltriggers" = 0 WHERE
"relname" = ''table_name'';
***QUERY***;
UPDATE pg_class SET reltriggers = (SELECT count(*)
FROM pg_trigger where pg_class.oid = tgrelid) WHERE
relname = ''table_name'';
obviously this doesn't work for rules, anyone know how
can I do??
thanks,
by
danilo
______________________________________________________________________
Scarica il nuovo Yahoo! Messenger: con webcam, nuove faccine e tante altre novità.
http://it.yahoo.com/mail_it/foot/?http://it.messenger.yahoo.com/
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
