Re: WITH CHECK OPTION for auto-updatable views - Mailing list pgsql-hackers

From Dean Rasheed
Subject Re: WITH CHECK OPTION for auto-updatable views
Date
Msg-id CAEZATCWR8G63NA0numrsam+EUOBcmyHA7iBHfZCF+cTjtGWhXA@mail.gmail.com
Whole thread Raw
In response to WITH CHECK OPTION for auto-updatable views  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Responses Re: WITH CHECK OPTION for auto-updatable views
List pgsql-hackers
On 9 June 2013 11:14, Dean Rasheed <dean.a.rasheed@gmail.com> wrote:
> Here's a rebased version of the patch implementing WITH CHECK OPTION
> for auto-updatable views.
>
> It now includes documentation, and a clearer description of the
> patch's limitations --- WITH CHECK OPTION is only supported on
> auto-updatable views, not trigger-updatable or rule-updatable views. I
> believe that's compatible with the following features from the SQL
> standard:
>
> F311-04 Schema definition statement     CREATE VIEW: WITH CHECK OPTION
> F751    View CHECK enhancements
>

Here's an updated version --- I missed the necessary update to the
check_option column of information_schema.views.

Regards,
Dean

Attachment

pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Parallell Optimizer
Next
From: Dean Rasheed
Date:
Subject: MD5 aggregate