Re: [SQL] Views Readonly Still?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Zot O'Connor" <zot(at)ZotConsulting(dot)com>
Cc: postgres sql <pgsql-sql(at)hub(dot)org>
Subject: Re: [SQL] Views Readonly Still?
Date: 1999-07-24 23:38:02
Message-ID: 11299.932859482@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Zot O'Connor" <zot(at)ZotConsulting(dot)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

Browse pgsql-sql by date

  From Date Subject
Next Message Philip Warner 1999-07-25 00:18:24 Re: [HACKERS] Re: [SQL] inserts/updates problem under stressing !
Previous Message Hector M Banda 1999-07-24 23:35:15 Questions about Postgresql and other databases