Received: from web12907.mail.yahoo.com (web12907.mail.yahoo.com
	[216.136.174.74])
	by postgresql.org (Postfix) with SMTP id F25BE475498
	for <pgsql-sql@postgresql.org>; Thu,  1 Aug 2002 05:28:49 -0400 (EDT)
Message-ID: <20020801092852.29509.qmail@web12907.mail.yahoo.com>
Received: from [80.19.150.245] by web12907.mail.yahoo.com via HTTP;
	Thu, 01 Aug 2002 11:28:51 CEST
Date: Thu, 1 Aug 2002 11:28:51 +0200 (CEST)
From: =?iso-8859-1?q?friedrich=20nietzsche?= <nietzsche_psql@yahoo.it>
Subject: How to disable rules??
To: pgsql-sql <pgsql-sql@postgresql.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Archive-Number: 200208/5
X-Sequence-Number: 8851

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/