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

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: [COMMITTERS] pgsql: WITH CHECK OPTION support for auto-updatable VIEWs
Дата
Msg-id 20130730104724.GA4453@depesz.com
обсуждение исходный текст
Ответ на Re: [COMMITTERS] pgsql: WITH CHECK OPTION support for auto-updatable VIEWs  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Dean Rasheed
Дата:
Сообщение: Re: [COMMITTERS] pgsql: WITH CHECK OPTION support for auto-updatable VIEWs
Следующее
От: Greg Smith
Дата:
Сообщение: Re: ALTER SYSTEM SET command to change postgresql.conf parameters (RE: Proposal for Allow postgresql.conf values to be changed via SQL [review])