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

Re: Inheritance docs error.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Paul Govereau <pgoverea(at)akamai(dot)com>, pgsql-docs(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Inheritance docs error.
Date: 2000-12-30 20:08:46
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-docspgsql-hackers
Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
>>>> They are all correct:  UNDER is the new SQL99 syntax, INHERITS is the
>>>> traditional Postgres syntax.
>> Current docs do appear to be erroneous: they claim the UNDER phrase goes
>> where INHERIT does, which is not what the grammar thinks.  I haven't
>> looked at SQL99 to see which is right.

> The grammar appears to be correct to the extent that SQL99 wants the UNDER
> before the column list, so I corrected the documentation at that point.
> However, the syntax as a whole is not SQL99-compliant.

Hmm.  After looking at the SQL99 syntax, it seems that what we've done
with our grammar is to take the old INHERITS functionality and plaster
a vaguely-SQL-like syntax on it.  I have to wonder whether this is a
good idea.  I think it'll get in the way when and if we want to offer
true SQL99 UNDER behavior, which is only marginally related to INHERITS.
(In particular, SQL99 seems to want an explicit specification of the
structured type that's being inherited.)

I am strongly inclined to rip out the pseudo-UNDER clause and support
only the old-style INHERITS syntax for 7.1.  UNDER is adding no
functionality and I think we will eventually regret using an SQL keyword
for non-SQL semantics.


			regards, tom lane

In response to


pgsql-docs by date

Next:From: Michael GraffDate: 2000-12-30 20:18:43
Subject: Re: Rather incorrect text in admin guide
Previous:From: Peter EisentrautDate: 2000-12-30 19:12:32
Subject: Re: Inheritance docs error.

pgsql-hackers by date

Next:From: Patrick WelcheDate: 2000-12-30 21:34:16
Subject: Re: GNU readline and BSD license
Previous:From: Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=Date: 2000-12-30 20:04:28
Subject: Re: GNU readline and BSD license

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