Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] Views Readonly Still? - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] Views Readonly Still?
Date
Msg-id 11299.932859482@sss.pgh.pa.us
Whole thread Raw
In response to Views Readonly Still?  ("Zot O'Connor" <zot@ZotConsulting.com>)
List pgsql-sql
Tree view 
"Zot O'Connor" <zot@ZotConsulting.com> writes:
> Are views readonly in 6.51 still?

A view as such is just a SELECT rule; if you want to make it
writable then you need to add some ON INSERT and ON UPDATE and
ON DELETE rules to cause the right things to happen wherever the
data is coming from.  There's no way that the system can intuit
what you might think is the correct behavior...
        regards, tom lane

pgsql-sql by date:

Previous
From: Hector M Banda
Date:
Subject: Questions about Postgresql and other databases
Next
From: Philip Warner
Date:
Subject: Re: [HACKERS] Re: [SQL] inserts/updates problem under stressing !