From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Timothy Covell <dirac(at)applink(dot)net>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: What's ETA for read/write Views? |
Date: | 2000-08-04 21:59:09 |
Message-ID: | Pine.LNX.4.21.0008042314290.1568-100000@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-08-06 05:33:54 | Re: A question about indexes... |
Previous Message | Michael Richards | 2000-08-04 18:48:47 | Database in recovery mode |