From: friedrich nietzsche <nietzsche_psql@yahoo.it>
To: pgsql-sql <pgsql-sql@postgresql.org>
Subject: How to disable rules??
Date: Thu, 1 Aug 2002 11:28:51 +0200 (CEST)
Message-ID: <20020801092852.29509.qmail@web12907.mail.yahoo.com> (raw)
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: nietzsche_psql@yahoo.it
Subject: Re: How to disable rules??
In-Reply-To: <20020801092852.29509.qmail@web12907.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox