Re: PostgreSQL 9.0 - Mailing list pgsql-general

From Bernd Helmle
Subject Re: PostgreSQL 9.0
Date
Msg-id e5795b486a9cfe7bad98dffc27058c5b@oopsware.de
Whole thread Raw
In response to Re: PostgreSQL 9.0  ("Karen Hill" <karen_hill22@yahoo.com>)
List pgsql-general


On 30 Jan 2007 12:15:17 -0800, "Karen Hill" <karen_hill22@yahoo.com> wrote:
> On Jan 29, 11:06 pm, qne...@gmail.com ("Dawid Kuroczko") wrote:
>
>> * updatable views [ or am I missing something? ] -- it seems to me
>> they were close to be completed, but I don't remember if they were
>> completed and committed or not.
>>
>
> PostgreSQL has updatable views via the rules system.  I use updatable
> views all the time in postgres.
>
>

The point is that you can't do things with the rule system reliable the SQL standard
tells us to do. The CHECK OPTION is an example, this can't be modeled
using rules only.

Bernd

pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: Any Plans for cross database queries on the same server?
Next
From: "Mikael Carneholm"
Date:
Subject: Re: DBMS Engines and Performance