Horton
Menu

Re: Proof of concept: auto updatable views [Review of Patch]

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Fetter <david@fetter.org>
Cc: Dean Rasheed <dean.a.rasheed@gmail.com>, Peter Eisentraut <peter_e@gmx.net>, Amit kapila <amit.kapila@huawei.com>, "robertmhaas@gmail.com" <robertmhaas@gmail.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2012-11-07T22:55:32Z
Lists: pgsql-hackers 
David Fetter <david@fetter.org> writes:
> On Wed, Nov 07, 2012 at 05:04:48PM -0500, Tom Lane wrote:
>> Should we be doing something
>> about such cases, or is playing dumb correct?

> The SQL standard handles deciding the behavior based on whether WITH
> CHECK OPTION is included in the view DDL.  See the section 2 of the
> SQL standard (Foundation) for details.

Ah, I see it.  So as long as we don't support WITH CHECK OPTION, we
can ignore the issue.

			regards, tom lane