Postgres Pro
Downloads
Home   >   mailing lists

Re: [COMMITTERS] pgsql: WITH CHECK OPTION support for auto-updatable VIEWs - Mailing list pgsql-hackers

From hubert depesz lubaczewski
Subject Re: [COMMITTERS] pgsql: WITH CHECK OPTION support for auto-updatable VIEWs
Date
Msg-id 20130730104724.GA4453@depesz.com
Whole thread Raw
In response to Re: [COMMITTERS] pgsql: WITH CHECK OPTION support for auto-updatable VIEWs  (Dean Rasheed <dean.a.rasheed@gmail.com>)
List pgsql-hackers
Tree view 
On Tue, Jul 30, 2013 at 11:45:47AM +0100, Dean Rasheed wrote:
> Quoting the manual:
> 
> LOCAL:
>   New rows are only checked against the conditions defined directly in
> the view itself. Any conditions defined on underlying base views are
> not checked (unless they also specify the CHECK OPTION).
> 
> CASCADED:
>   New rows are checked against the conditions of the view and all
> underlying base views. If the CHECK OPTION is specified, and neither
> LOCAL nor CASCADED is specified, then CASCADED is assumed.
> 
> In particular, note the part about "unless they also specify the CHECK OPTION".

Ah. All clear now. Sorry for misreading.

Best regards,

depesz

pgsql-hackers by date:

Previous
From: Dean Rasheed
Date:
Subject: Re: [COMMITTERS] pgsql: WITH CHECK OPTION support for auto-updatable VIEWs
Next
From: Greg Smith
Date:
Subject: Re: ALTER SYSTEM SET command to change postgresql.conf parameters (RE: Proposal for Allow postgresql.conf values to be changed via SQL [review])