X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.193])
	by svr1.postgresql.org (Postfix) with ESMTP id 5B31630F1DB
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 17:34:25 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new,
	port 10024) with ESMTP id 63322-01
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 14:34:15 -0300 (ADT)
Received: from trade-india.com (ns1.trade-india.com [66.234.10.14])
	by svr1.postgresql.org (Postfix) with SMTP id 6423930F1D1
	for <pgsql-sql@postgresql.org>; Tue, 17 Jun 2003 14:34:14 -0300 (ADT)
Received: (qmail 17590 invoked by uid 505); 17 Jun 2003 17:34:16 -0000
Received: from mallah@trade-india.com by ns1.trade-india.com by uid 502 with
	qmail-scanner-1.16
	(clamscan: 0.54. spamassassin: 2.54.  Clear:SA:0(-98.1/5.0):.
	Processed in 0.552152 secs); 17 Jun 2003 17:34:16 -0000
Received: from ns1.trade-india.com (HELO trade-india.com) (66.234.10.14)
	by ns1.trade-india.com with SMTP; 17 Jun 2003 17:34:14 -0000
Received: from 219.65.230.103 (SquirrelMail authenticated user mallah)
	by mail.trade-india.com with HTTP;
	Tue, 17 Jun 2003 23:04:14 +0530 (IST)
Message-ID: <1164.219.65.230.103.1055871254.squirrel@mail.trade-india.com>
Date: Tue, 17 Jun 2003 23:04:14 +0530 (IST)
Subject: disabling triggers
From: <mallah@trade-india.com>
To: <pgsql-sql@postgresql.org>
X-Priority: 3
Importance: Normal
X-MSMail-Priority: Normal
X-Mailer: SquirrelMail (version 1.2.6)
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0
	tests=MISSING_MIMEOLE, MISSING_OUTLOOK_NAME, NO_REAL_NAME
X-Spam-Level: *
X-Archive-Number: 200306/192
X-Sequence-Number: 13950


Hi,

Is setting reltriggers=0 on pg_class an  accepatble way of
disabling triggers on a table temporarily?

secondly is it worth having commands like
alter trigger <triggername> inactive;
alter trigger <triggername> active ;
i feel such commands exists on Oracle.

sometime we need to bulk update tables from backdoor
and we feel the trigger execution to be unneccessary.


regds
mallah.


-----------------------------------------
Get your free web based email at trade-india.com.
   "India's Leading B2B eMarketplace.!"
http://www.trade-india.com/