Re: WIP: Automatic view update rules - Mailing list pgsql-hackers

From Robert Haas
Subject Re: WIP: Automatic view update rules
Date
Msg-id 603c8f070812280649t6be5f784h91a40d6049abeae0@mail.gmail.com
Whole thread Raw
In response to WIP: Automatic view update rules  (Bernd Helmle <mailings@oopsware.de>)
List pgsql-hackers
>> 2) Another less important bug, the WITH CHECK OPTION is accepted even
>> when that functionality is not implemented.
>>
>> updatable_views=# create or replace view v2 as select * from foo where
>> id < 10 with check option;
>> NOTICE:  CREATE VIEW will create implicit INSERT/UPDATE/DELETE rules
>> CREATE VIEW
> What do we want in this case? We can throw an error telling that CHECK
> OPTION isn't supported yet or simply issueing a warning.

+1 for an error.

...Robert


pgsql-hackers by date:

Previous
From: "Robert Haas"
Date:
Subject: Re: Proposed Patch to Improve Performance of Multi-BatchHash Join for Skewed Data Sets
Next
From: "Bernd Helmle"
Date:
Subject: Re: WIP: Automatic view update rules