Re: WIP: Triggers on VIEWs

Dean Rasheed <dean.a.rasheed@gmail.com>

From: Dean Rasheed <dean.a.rasheed@gmail.com>

To: pgsql-hackers@postgresql.org

Date: 2010-09-05T08:09:55Z

Lists: pgsql-hackers

Attachments

view_triggers.patch (application/octet-stream) patch

On 15 August 2010 18:38, Dean Rasheed <dean.a.rasheed@gmail.com> wrote:
> Here is a WIP patch implementing triggers on VIEWs ... <snip>
>
> There are still a number of things left todo:
>  - extend ALTER VIEW with enable/disable trigger commands
>  - much more testing
>  - documentation
>

Attached is an updated patch with more tests and docs, and a few minor
code tidy ups. I think that the INSTEAD OF triggers part of the patch
is compliant with Feature T213 of the SQL 2008 standard. As discussed,
I don't plan to add the syntax to allow triggers on views to be
disabled at this time, but that should be easy to implement, if there
is a use case for it.

Comments welcome.

Regards,
Dean