db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edson Carlos Ericksson Richter <edson.rich...@mgrinformatica.com.br>
Subject Re: Trigger on Views
Date Fri, 11 Aug 2006 15:11:23 GMT
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
>
>
>


Mime
View raw message