Re: WIP: Automatic view update rules

From: "Robert Haas" <robertmhaas(at)gmail(dot)com>
To: "Bernd Helmle" <bernd(at)oopsware(dot)de>
Cc: "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>, "Bernd Helmle" <mailings(at)oopsware(dot)de>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: WIP: Automatic view update rules
Date: 2008-12-28 14:49:27
Message-ID: 603c8f070812280649t6be5f784h91a40d6049abeae0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2008-12-28 14:56:54 Re: Windowing Function Patch Review -> Standard Conformance
Previous Message Robert Haas 2008-12-28 14:47:47 Re: Proposed Patch to Improve Performance of Multi-BatchHash Join for Skewed Data Sets