X-Original-To: pgsql-sql@postgresql.org
Received: from poweredge.attiksystem.ch (adsl-soholight-4-c59-p029.vtx.ch
	[212.147.59.29])
	by svr1.postgresql.org (Postfix) with ESMTP id 86C2F5E473F
	for <pgsql-sql@postgresql.org>; Tue, 24 Aug 2004 04:41:58 -0300 (ADT)
Subject: Disable trigger with Postgresql 7.4.x?
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Date: Tue, 24 Aug 2004 09:41:58 +0200
X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1
content-class: urn:content-classes:message
Message-ID: <6C0CF58A187DA5479245E0830AF84F420803D3@poweredge.attiksystem.ch>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Disable trigger with Postgresql 7.4.x?
Thread-Index: AcSJrdWZN5Nvu7JgTmawNjeDHUPvgQ==
From: "Philippe Lang" <philippe.lang@attiksystem.ch>
To: <pgsql-sql@postgresql.org>
X-Archive-Number: 200408/249
X-Sequence-Number: 18746

Hello,

I read in an old thread

http://archives.postgresql.org/pgsql-hackers/2002-08/msg00079.php

... that starting with Postgresql 7.3, there is a new way to disable and
enable triggers in Postgresql. The "old" way was:

update pg_class set reltriggers=3D0 where relname =3D 'YOUR_TABLE_NAME';
update pg_class set reltriggers =3D count(*) from pg_trigger where
pg_class.oid=3Dtgrelid and relname=3D'YOUR_TABLE_NAME';

What is the recommended way of doing that under Postgresql 7.4.x?

Thanks

Philippe Lang