Re: Incomplete compatibility information for triggers

From: Louis-Claude Canon <louis-claude(dot)canon(at)femto-st(dot)fr>
To: Josh Kupershmidt <schmiddy(at)gmail(dot)com>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: Incomplete compatibility information for triggers
Date: 2012-11-14 21:19:39
Message-ID: 50A40AEB.1020804@femto-st.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Le 14/11/2012 05:23, Josh Kupershmidt a écrit :
> On Sun, Nov 11, 2012 at 3:52 PM, Louis-Claude Canon
> <louis-claude(dot)canon(at)femto-st(dot)fr> wrote:
>
>> 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.
> +1, it seems like a useful missing piece from the SQL:2011 standard.
> Care to send a documentation patch?

Let me know if it requires a second round.

By the way, I can propose another patch regarding the transaction
isolation relatively to my previous post on pgsql-bugs.

Louis

Attachment Content-Type Size
0001-Document-the-missing-OLD-NEW-TABLE-trigger-feature.patch text/x-patch 0 bytes

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Robert Haas 2012-11-14 22:46:57 Re: Add contrib module functions to docs' function index
Previous Message Josh Kupershmidt 2012-11-14 04:23:13 Re: Incomplete compatibility information for triggers