| 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: | Whole Thread | Raw Message | 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 |