pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedWhat'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>
2000-08-01 01:33 ` Re: What's ETA for read/write Views? Tom Lane <tgl@sss.pgh.pa.us>
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-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>
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