Re: Proposal for updatable views

"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