Thread: mistake in sql99 compatibility?
The cvs docs say that we support the 'WITH CHECK OPTION' on views, but the TODO says we don't... Chris
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, Pennsylvania19026
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
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
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, Pennsylvania19026
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 >