pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Views Readonly Still?
2+ messages / 2 participants
[nested] [flat]

* Views Readonly Still?
@ 1999-07-24 18:53 Zot O'Connor <zot@ZotConsulting.com>
  1999-07-24 23:38 ` Re: [SQL] Views Readonly Still? Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Zot O'Connor @ 1999-07-24 18:53 UTC (permalink / raw)
  To: postgres sql <pgsql-sql@hub.org>

Are views readonly in 6.51 still?

-- 
Zot O'Connor

www.ZotConsulting.com
www.WhiteKnightHackers.com



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [SQL] Views Readonly Still?
  1999-07-24 18:53 Views Readonly Still? Zot O'Connor <zot@ZotConsulting.com>
@ 1999-07-24 23:38 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 1999-07-24 23:38 UTC (permalink / raw)
  To: Zot O'Connor <zot@ZotConsulting.com>; +Cc: postgres sql <pgsql-sql@hub.org>

"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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1999-07-24 23:38 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-07-24 18:53 Views Readonly Still? Zot O'Connor <zot@ZotConsulting.com>
1999-07-24 23:38 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox