Re: WIP: Triggers on VIEWs - Mailing list pgsql-hackers

From Dean Rasheed
Subject Re: WIP: Triggers on VIEWs
Date
Msg-id AANLkTikjZ-aQDxWFd-XdoTYeSBkWvhbraZNQrvC2hYPv@mail.gmail.com
Whole thread Raw
In response to WIP: Triggers on VIEWs  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Responses Re: WIP: Triggers on VIEWs  (David Christensen <david@endpoint.com>)
Re: WIP: Triggers on VIEWs  (Bernd Helmle <mailings@oopsware.de>)
List pgsql-hackers
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

Attachment

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: proposal: tsearch dictionary initialization hook
Next
From: Heikki Linnakangas
Date:
Subject: Re: ps buffer is incorrectly padded on the (latest) OS X