Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Re: Inheritance docs error.

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Robert B(dot) Easter" <reaster(at)comptechnews(dot)com>, Peter Eisentraut <peter_e(at)gmx(dot)net>, Paul Govereau <pgoverea(at)akamai(dot)com>, pgsql-docs(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Re: Inheritance docs error.
Date: 2001-01-03 09:30:51
Message-ID: 3A52F14B.10FE6D8C@tm.ee (view raw or flat)
Thread:
Lists: pgsql-docspgsql-hackers
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

In response to

Responses

pgsql-docs by date

Next:From: drevilDate: 2001-01-03 09:59:33
Subject: Re: MySQL and PostgreSQL speed compare
Previous:From: ansonDate: 2001-01-03 08:04:36
Subject: Sequence

pgsql-hackers by date

Next:From: Frank JoerdensDate: 2001-01-03 13:44:32
Subject: Re: [INTERFACES] Re: PHP and PostgreSQL
Previous:From: Bruce MomjianDate: 2001-01-03 07:14:15
Subject: Please review TODO list

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group