Re: Proposal for updatable views - Mailing list pgsql-hackers

From William ZHANG
Subject Re: Proposal for updatable views
Date
Msg-id dv1f94$1ctr$1@news.hub.org
Whole thread Raw
In response to Proposal for updatable views  (Bernd Helmle <mailings@oopsware.de>)
Responses Re: Proposal for updatable views  (Neil Conway <neilc@samurai.com>)
List 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 by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: ERROR: record type has not been registered on CVS head
Next
From: "Jonah H. Harris"
Date:
Subject: DB2-style INS/UPD/DEL RETURNING