Skip site navigation (1) Skip section navigation (2)

Re: Updateable views...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Eric D Nielsen <nielsene(at)MIT(dot)EDU>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Updateable views...
Date: 2003-03-05 00:03:05
Message-ID: 15424.1046822585@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Eric D Nielsen <nielsene(at)MIT(dot)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

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2003-03-05 00:14:23
Subject: Re: [PATCHES] ALTER SEQUENCE
Previous:From: Alan GutierrezDate: 2003-03-04 23:27:03
Subject: Re: XML ouput for psql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group