How to disable rules?? - Mailing list pgsql-sql

From friedrich nietzsche
Subject How to disable rules??
Date
Msg-id 20020801092852.29509.qmail@web12907.mail.yahoo.com
Whole thread Raw
Responses Function problems, cache lookup failed  (Archibald Zimonyi <archie@netg.se>)
List pgsql-sql
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/


pgsql-sql by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Please Help me
Next
From: Archibald Zimonyi
Date:
Subject: Function problems, cache lookup failed