On Tue, 4 Mar 2003, Eric D Nielsen wrote: > The one place I haven't been able to use PostGreSQL to experiment is > with regards to updateable views. I've found a few threads in > -general and -hackers (including one linked from the ToDo list), but > they all seem to die out without really reaching any sort of > conclusion. I've also seen that in many cases it appears possible to > use triggers/rules to simulate updateable views, but that feels like > an inelegant solution to me.
At some of the conferences I've been to, updatable/insertable-into views are a big request. I've looked into the spec, which basically said that views can be marked updatable/insertable-into if all attributes into the query expression are updatable/insertable into. I haven't had time to look into it further, but it occurs to me that handling views which rely on joins would be far from trivial. (The big selling point of views, for me, is as a means of tying together objects so that an application has a simplified interface to application logic). Anyone else do anything on this? Gavin ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster