pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
What's ETA for read/write Views?
3+ messages / 3 participants
[nested] [flat]

* What's ETA for read/write Views?
@ 2000-07-31 23:59  Timothy Covell <dirac@applink.net>
  0 siblings, 1 reply; 3+ messages in thread

From: Timothy Covell @ 2000-07-31 23:59 UTC (permalink / raw)
  To: pgsql-sql


I'm working on a project and using postgres 7.0.2
with phpPgAdmin and php3.0.16.  Anyhow, the more
I learn about relations database systems, the more
orthogonal my data becomes.  However, I then need
to have read/write views so that "ordinary" humans
can make sense of the data....
    While, I'm at it. I've always disliked MySQL
because it wasn't GPL'd nor was it a real RDBMS.
Anyhow, from what I can tell, they went GPL because
that was the only way to move forward due to their
BDB kludge.....Just my 2 cents....

TIA.
tim
dirac@applink.net




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

* Re: What's ETA for read/write Views?
@ 2000-08-01 01:33  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Timothy Covell <dirac@applink.net>
  0 siblings, 0 replies; 3+ messages in thread

From: Tom Lane @ 2000-08-01 01:33 UTC (permalink / raw)
  To: Timothy Covell <dirac@applink.net>; +Cc: pgsql-sql

Read-write views exist now: you just have to write ON INSERT,
ON UPDATE, ON DELETE rules that show what you think should happen.

Some people seem to think that the system should try to intuit
those rules for them, but I don't believe that's either possible
or desirable.  The entire point of a view is that it's not an
exact image of the underlying data, so how is a machine going to
figure out what you want an update on the view to do?

			regards, tom lane



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

* Re: What's ETA for read/write Views?
@ 2000-08-04 21:59  Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 0 replies; 3+ messages in thread

From: Peter Eisentraut @ 2000-08-04 21:59 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Timothy Covell <dirac@applink.net>; pgsql-sql

Tom Lane writes:

> Some people seem to think that the system should try to intuit
> those rules for them, but I don't believe that's either possible
> or desirable.  The entire point of a view is that it's not an
> exact image of the underlying data, so how is a machine going to
> figure out what you want an update on the view to do?

The SQL standard has pretty precise rules for when views are updatable and
how.


-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden




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


end of thread, other threads:[~2000-08-04 21:59 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-07-31 23:59 What's ETA for read/write Views? Timothy Covell <dirac@applink.net>
2000-08-01 01:33 ` Tom Lane <tgl@sss.pgh.pa.us>
2000-08-04 21:59 Re: What's ETA for read/write Views? Peter Eisentraut <peter_e@gmx.net>

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