X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A3E93D1DD26 for ; Mon, 9 Feb 2004 07:47:05 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 08946-02 for ; Mon, 9 Feb 2004 03:46:51 -0400 (AST) Received: from poweredge.attiksystem.ch (adsl-soholight-4-c59-p029.vtx.ch [212.147.59.29]) by svr1.postgresql.org (Postfix) with ESMTP id 7E312D1C967 for ; Mon, 9 Feb 2004 03:46:39 -0400 (AST) content-class: urn:content-classes:message Subject: Disable/Enable Trigger? MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Date: Mon, 9 Feb 2004 08:46:40 +0100 X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 Message-ID: <6C0CF58A187DA5479245E0830AF84F420AFB68@poweredge.attiksystem.ch> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Disable/Enable Trigger? Thread-Index: AcPu4OyLtvLKo0QRS46R7DiuVWp8/w== From: "Philippe Lang" To: X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/75 X-Sequence-Number: 16766 Hello, How can I disable a trigger in a function, and then enable it again? I'm using PG 7.3.4. Do I have to delete it, and create it again? Thanks Philippe