Re: What's ETA for read/write Views? - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: What's ETA for read/write Views?
Date
Msg-id Pine.LNX.4.21.0008042314290.1568-100000@localhost.localdomain
Whole thread Raw
In response to What's ETA for read/write Views?  (Timothy Covell <dirac@applink.net>)
List 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



pgsql-sql by date:

Previous
From: "Michael Richards"
Date:
Subject: Database in recovery mode
Next
From: Tom Lane
Date:
Subject: Re: A question about indexes...