mistake in sql99 compatibility?

Christopher Kings-Lynne wrote:

The cvs docs say that we support the 'WITH CHECK OPTION' on views, but the
TODO says we don't...

TODO updated. Not sure when it was added but I see it in SGML docs.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Bruce Momjian <pgman@candle.pha.pa.us> writes:

Christopher Kings-Lynne wrote:

The cvs docs say that we support the 'WITH CHECK OPTION' on views, but the
TODO says we don't...

TODO updated. Not sure when it was added but I see it in SGML docs.

A moment's examination of gram.y would have convinced you that the
docs are wrong ...

regards, tom lane

Tom Lane wrote:

Bruce Momjian <pgman@candle.pha.pa.us> writes:

Christopher Kings-Lynne wrote:

The cvs docs say that we support the 'WITH CHECK OPTION' on views, but the
TODO says we don't...

TODO updated. Not sure when it was added but I see it in SGML docs.

A moment's examination of gram.y would have convinced you that the
docs are wrong ...

Oh, OK. In the future, the "A moment's examination" swipe isn't
required. :-( I suppose it makes you feel better.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

On Fri, Jun 28, 2002 at 02:57:27PM -0400, Bruce Momjian wrote:

Christopher Kings-Lynne wrote:

The cvs docs say that we support the 'WITH CHECK OPTION' on views, but the
TODO says we don't...

TODO updated. Not sure when it was added but I see it in SGML docs.

On a related note, the SQL99 feature list in the development docs says
that we support the SQL99 UNIQUE predicate. AFAIK we don't -- should
the docs be updated?

Cheers,

Neil

--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC

Sure? I don't see it. In fact, I only see it in the 'SQL92 features we
don't have section'.

http://developer.postgresql.org/docs/postgres/sql-createview.html

Chris

----- Original Message -----
From: "Bruce Momjian" <pgman@candle.pha.pa.us>
To: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Cc: <pgsql-hackers@postgresql.org>
Sent: Saturday, June 29, 2002 2:57 AM
Subject: Re: [HACKERS] mistake in sql99 compatibility?

Christopher Kings-Lynne wrote:

The cvs docs say that we support the 'WITH CHECK OPTION' on views, but

the