X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (mx2.hub.org [200.46.204.254]) by postgresql.org (Postfix) with ESMTP id 2788711F6647 for ; Fri, 21 Apr 2006 11:38:09 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: -2.387 X-Spam-Level: X-Spam-Status: No, score=-2.387 required=5 tests=[AWL=0.214, BAYES_00=-2.599, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001] Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id zqoIHj89P2-E for ; Fri, 21 Apr 2006 11:38:05 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id BA27111F663F for ; Fri, 21 Apr 2006 11:38:02 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k3LEc3wh009597; Fri, 21 Apr 2006 10:38:03 -0400 (EDT) To: Andreas Haumer cc: pgsql-sql@postgresql.org Subject: Re: Porting application with rules and triggers from PG 7.4.x to 8.1.3 In-reply-to: <4448C8EA.2040601@xss.co.at> References: <4448C8EA.2040601@xss.co.at> Comments: In-reply-to Andreas Haumer message dated "Fri, 21 Apr 2006 13:58:34 +0200" Date: Fri, 21 Apr 2006 10:38:02 -0400 Message-ID: <9596.1145630282@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200604/146 X-Sequence-Number: 24955 Andreas Haumer writes: > How can I get the functionality of an "deferred AFTER trigger" > again with PostgreSQL 8? Use CREATE CONSTRAINT TRIGGER. The manual is fairly negative about this but I don't actually foresee it going away any time soon. regards, tom lane