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

From Dean Rasheed
Subject WITH CHECK OPTION for auto-updatable views
Date
Msg-id CAEZATCVQTC+ovWr9kzuj5Q6SkOqZFNih=-V=eLGc704KBi=Lqw@mail.gmail.com
Whole thread Raw
Responses Re: WITH CHECK OPTION for auto-updatable views  (Dean Rasheed <dean.a.rasheed@gmail.com>)
List pgsql-hackers
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

Regards,
Dean

Attachment

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Optimising Foreign Key checks
Next
From: Craig Ringer
Date:
Subject: Re: Vacuum, Freeze and Analyze: the big picture