You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by Alexander Schatten <al...@gmx.at> on 2006/08/11 15:28:51 UTC

Trigger on Views

I am right now trying to get a better understanding of Derby Triggers. I 
think the current implementation is nice, particularly also the SQL 
based triggers.

However, I wonder about one thing: is it possible (or planned) to allow 
triggers on views?

This might sound odd, but as Derby is unfortunately not supporting 
updateable views, a "before" trigger on a view could be a nice 
workaround to create "pseudo-updatable" views.

I think older Postgresql versions could do that.


Alex

Re: Trigger on Views

Posted by Edson Carlos Ericksson Richter <ed...@mgrinformatica.com.br>.

Also known as "instead of triggers" on other databases.

Richter


Alexander Schatten escreveu:
> I am right now trying to get a better understanding of Derby Triggers. 
> I think the current implementation is nice, particularly also the SQL 
> based triggers.
>
> However, I wonder about one thing: is it possible (or planned) to 
> allow triggers on views?
>
> This might sound odd, but as Derby is unfortunately not supporting 
> updateable views, a "before" trigger on a view could be a nice 
> workaround to create "pseudo-updatable" views.
>
> I think older Postgresql versions could do that.
>
>
> Alex
>
>
>