X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 375A4D1D575 for ; Fri, 16 Jan 2004 13:05:50 +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 34139-05 for ; Fri, 16 Jan 2004 09:05:21 -0400 (AST) Received: from main.gmane.org (main.gmane.org [80.91.224.249]) by svr1.postgresql.org (Postfix) with ESMTP id 64BEDD1DF84 for ; Fri, 16 Jan 2004 09:05:18 -0400 (AST) Received: from list by main.gmane.org with local (Exim 3.35 #1 (Debian)) id 1AhTf7-0000gC-00 for ; Fri, 16 Jan 2004 14:05:21 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-performance@postgresql.org Received: from sea.gmane.org ([80.91.224.252]) by main.gmane.org with esmtp (Exim 3.35 #1 (Debian)) id 1AhTf6-0000g4-00 for ; Fri, 16 Jan 2004 14:05:20 +0100 Received: from news by sea.gmane.org with local (Exim 3.35 #1 (Debian)) id 1AhTf6-0004yp-00 for ; Fri, 16 Jan 2004 14:05:20 +0100 From: Harald Fuchs Subject: Re: Trigger question Date: 16 Jan 2004 14:05:20 +0100 Organization: Linux Private Site Lines: 10 Message-ID: References: <400691EA.96598C34@t1.unisoftbg.com> <200401151610.38270.dev@archonet.com> <1022542776.20040115180811@evilazrael.de> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@sea.gmane.org X-No-Archive: yes User-Agent: Gnus/5.0808 (Gnus v5.8.8) Emacs/20.7 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/166 X-Sequence-Number: 5341 In article <1022542776.20040115180811@evilazrael.de>, Evil Azrael writes: > That not, but perhaps a STATEMENT Level Trigger could help. Itīs a new > feature in 7.4.x and rather undocumented. http://www.postgresql.org/docs/current/interactive/sql-createtrigger.html > "FOR EACH STATEMENT" probably this can help you a bit. Does anyone know how to access the affected values for statement-level triggers? I mean what the "old" and "new" pseudo-records are for row-level triggers.