Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TXeWe-0004BO-7o for pgsql-docs@postgresql.org; Sun, 11 Nov 2012 20:53:04 +0000 Received: from lifc.univ-fcomte.fr ([194.57.88.66] helo=lifc-proxy.univ-fcomte.fr) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TXeWb-0002gg-8F for pgsql-docs@postgresql.org; Sun, 11 Nov 2012 20:53:03 +0000 Received: from [192.168.0.10] (stp25-1-82-226-151-110.fbx.proxad.net [82.226.151.110]) (authenticated bits=0) by lifc-proxy.univ-fcomte.fr (8.14.3/8.14.3/Debian-5+lenny1) with ESMTP id qABKqvf2002581 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT) for ; Sun, 11 Nov 2012 21:52:58 +0100 Message-ID: <50A01024.5010007@femto-st.fr> Date: Sun, 11 Nov 2012 21:52:52 +0100 From: Louis-Claude Canon User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:16.0) Gecko/20121028 Thunderbird/16.0.2 MIME-Version: 1.0 To: pgsql-docs@postgresql.org Subject: Incomplete compatibility information for triggers Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201211/7 X-Sequence-Number: 7499 Hello, the compatibility section of the "create trigger" page (http://www.postgresql.org/docs/devel/static/sql-createtrigger.html) claims that a missing functionality is the ability to define aliases for the "old" and "new" rows or tables. If I am understanding this correctly, another related missing functionality is that PostgreSQL does not allow the old and new tables to be referenced for statement-level triggers (i.e., the "OLD TABLE" that contains all the deleted/modified rows in case of deletion/update). I think this is also worth noting as any workaround for it seems to be more difficult (if possible at all) than for the missing alias feature. Regards, Louis-Claude Canon