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 C538030EF42
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 18:17:33 +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 67581-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 15:17:23 -0300 (ADT)
Received: from trade-india.com (ns1.trade-india.com [66.234.10.14])
	by svr1.postgresql.org (Postfix) with SMTP id 5CB7B30E7CC
	for <pgsql-sql@postgresql.org>; Tue, 17 Jun 2003 15:17:21 -0300 (ADT)
Received: (qmail 23252 invoked by uid 505); 17 Jun 2003 18:17:23 -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(-99.1/5.0):.
	Processed in 0.513433 secs); 17 Jun 2003 18:17:23 -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 18:17:22 -0000
Received: from 219.65.230.103 (SquirrelMail authenticated user mallah)
	by mail.trade-india.com with HTTP;
	Tue, 17 Jun 2003 23:47:22 +0530 (IST)
Message-ID: <1175.219.65.230.103.1055873842.squirrel@mail.trade-india.com>
Date: Tue, 17 Jun 2003 23:47:22 +0530 (IST)
Subject: Re: disabling triggers
From: <mallah@trade-india.com>
To: <josh@agliodbs.com>
In-Reply-To: <200306171058.44814.josh@agliodbs.com>
References: <1164.219.65.230.103.1055871254.squirrel@mail.trade-india.com>
	<200306171058.44814.josh@agliodbs.com>
X-Priority: 3
Importance: Normal
X-MSMail-Priority: Normal
Cc: <pgsql-sql@postgresql.org>
X-Mailer: SquirrelMail (version 1.2.6)
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Archive-Number: 200306/196
X-Sequence-Number: 13954

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

Ok , but someone on list was scary few months back.

>
> Yes.  pg_dump does this.
>
>> secondly is it worth having commands like
>> alter trigger <triggername> inactive;
>> alter trigger <triggername> active ;
>> i feel such commands exists on Oracle.
>
> No, since DROP TRIGGER ... CREATE TRIGGER does the same thing in Postgres.

Agreed , but there is no easy way to view current trigger defination of
existing triggers before dropping from psql .

One has to go the long way of pg_dump -s -t tabname  to view a list.



regds
mallah.



>
> --
> -Josh Berkus
> Aglio Database Solutions
> San Francisco



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