| Lists: | pgsql-sql |
|---|
| From: | Timothy Covell <dirac(at)applink(dot)net> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | What's ETA for read/write Views? |
| Date: | 2000-07-31 23:59:51 |
| Message-ID: | 00036dbe0ee2e93c_mailit@smtp.applink.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 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(at)applink(dot)net
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Timothy Covell <dirac(at)applink(dot)net> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: What's ETA for read/write Views? |
| Date: | 2000-08-01 01:33:40 |
| Message-ID: | 19845.965093620@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 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