db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alexander Schatten <ala...@gmx.at>
Subject Trigger on Views
Date Fri, 11 Aug 2006 13:28:51 GMT
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.


View raw message