From: Hannu Krosing <hannu@tm.ee>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Robert B. Easter <reaster@comptechnews.com>
Cc: Peter Eisentraut <peter_e@gmx.net>
Cc: Paul Govereau <pgoverea@akamai.com>
Cc: pgsql-docs@postgresql.org
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Re: Inheritance docs error.
Date: Wed, 03 Jan 2001 11:30:51 +0200
Message-ID: <3A52F14B.10FE6D8C@tm.ee> (raw)
References: <Pine.LNX.4.30.0012302007350.776-100000@peter.localdomain>
<3794.978206926@sss.pgh.pa.us>
<3A500043.2386D0C3@tm.ee>
<01010201595503.09559@comptechnews>
<12912.978457736@sss.pgh.pa.us>
Tom Lane wrote:
>
> One thing that bothered me is that my reading of the SQL99 draft
> disallows the UNDER syntax you are using. I read:
>
> <table definition> ::=
> CREATE [ <table scope> ] TABLE <table name>
> <table contents source>
> [ ON COMMIT <table commit action> ROWS ]
>
> <table contents source> ::=
> <table element list>
> | OF <user-defined type>
> [ <subtable clause> ]
> [ <table element list> ]
>
> <subtable clause> ::=
> UNDER <supertable clause>
>
> <supertable clause> ::= <supertable name>
>
> It looks to me like "UNDER <table name>" cannot appear without a
> preceding "OF <user-defined type>". I am not clear on the semantic
> implications of the OF clause.
to me it seems that only this is OR-d : <table element list> | OF
<user-defined type>
and the rest ([ <subtable clause> ],[ <table element list> ])is just
optional
> Anyway, we seem to have a clear consensus to pull the UNDER clause from
> the grammar and stick with INHERITS for 7.1. I will take care of that
> in the next day or so.
Good.
-----------
Hannu
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: hannu@tm.ee, tgl@sss.pgh.pa.us, reaster@comptechnews.com, peter_e@gmx.net, pgoverea@akamai.com, pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Re: Inheritance docs error.
In-Reply-To: <3A52F14B.10FE6D8C@tm.ee>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox