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 |
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 |