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

Chris





Thu, 27 Jun 2002 17:40:00 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
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



Fri, 28 Jun 2002 14:57:27 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: mistake in sql99 compatibility?
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



Fri, 28 Jun 2002 15:21:33 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: mistake in sql99 compatibility? 
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



Fri, 28 Jun 2002 15:29:37 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: mistake in sql99 compatibility?
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



Fri, 28 Jun 2002 15:35:21 -0400
nconway@klamath.dyndns.org (Neil Conway)
Re: mistake in sql99 compatibility?
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
> > 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
>




Sat, 29 Jun 2002 12:14:56 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: mistake in sql99 compatibility?