How to disable rules??

From: friedrich nietzsche <nietzsche_psql(at)yahoo(dot)it>
To: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: How to disable rules??
Date: 2002-08-01 09:28:51
Message-ID: 20020801092852.29509.qmail@web12907.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Archibald Zimonyi 2002-08-01 09:47:35 Function problems, cache lookup failed
Previous Message Christopher Kings-Lynne 2002-08-01 06:49:42 Re: Please Help me