Re: Firebird and PostgreSQL at the DB Corral. - Mailing list pgsql-general

From Tom Lane
Subject Re: Firebird and PostgreSQL at the DB Corral.
Date
Msg-id 8989.1071686275@sss.pgh.pa.us
Whole thread Raw
In response to Re: Firebird and PostgreSQL at the DB Corral.  (Doug McNaught <doug@mcnaught.org>)
List pgsql-general
Doug McNaught <doug@mcnaught.org> writes:
> The only reason PG views aren't
> updateable by default is (AIUI) a lack of agreement on how they should
> work for complex view definitions.

Actually I think it's more that no one has felt like tackling it.  The
SQL spec only requires views to be updatable when they are "sufficiently
simple", and it turns out that the spec's constraints on "sufficiently
simple" eliminate all the doubtful cases.

            regards, tom lane

pgsql-general by date:

Previous
From: Sai Hertz And Control Systems
Date:
Subject: Re: Excel, OpenOffice and Postgres
Next
From: Christopher Murtagh
Date:
Subject: Re: Permissions issue?