Re: Proposal for updatable views

Поиск
Список
Период
Сортировка
От William ZHANG
Тема Re: Proposal for updatable views
Дата
Msg-id dv1f94$1ctr$1@news.hub.org
обсуждение исходный текст
Ответ на Proposal for updatable views  (Bernd Helmle <mailings@oopsware.de>)
Ответы Re: Proposal for updatable views  (Neil Conway <neilc@samurai.com>)
Список pgsql-hackers
"Bernd Helmle" <mailings@oopsware.de>
> Hi folks,
> The supported syntax is
>
> CREATE VIEW foo AS SELECT ... [WITH [LOCAL | CASCADED] CHECK OPTION];
>
> The LOCAL and CASCADED keywords are optional when a CHECK OPTION is
> specified, the default is CASCADED (this syntax creates a shift/reduce
> conflict in the grammar file i don't know how to fix).

Maybe you can fix it like UNIONJOIN.  See parser.c.
But Tom said he want to remove the support for  UNION JOIN and save the
overhead:   http://archives.postgresql.org/pgsql-hackers/2006-03/msg00344.php

Regards,
William ZHANG




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Stefan Kaltenbrunner
Дата:
Сообщение: ERROR: record type has not been registered on CVS head
Следующее
От: "Jonah H. Harris"
Дата:
Сообщение: DB2-style INS/UPD/DEL RETURNING