Re: Updateable views... - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Updateable views...
Date
Msg-id 15424.1046822585@sss.pgh.pa.us
Whole thread Raw
In response to Updateable views...  (Eric D Nielsen <nielsene@MIT.EDU>)
List pgsql-hackers
Eric D Nielsen <nielsene@MIT.EDU> writes:
> 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.

That's because we've discussed it about as far as is interesting, until
someone actually steps up and does the work ;-).  We know how it should
be implemented: in Postgres terms, an updateable-view facility would
simply mean generating the appropriate ON INSERT/UPDATE/DELETE rules
automatically, whenever a view is created that is simple enough that
the code can figure out what said rules ought to be.  (Hopefully this
condition will be pretty nearly equivalent to the rules the SQL spec
lays down for whether a view is updatable.)

> Are there people working on this topic?  I'ld be interested in helping out.

AFAIR, no one has done anything about it.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Alan Gutierrez
Date:
Subject: Re: XML ouput for psql
Next
From: Neil Conway
Date:
Subject: Re: Updateable views...