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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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