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/
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 |