From: Tom Lane <tgl@sss.pgh.pa.us>
To: Laurenz Albe <laurenz.albe@cybertec.at>
cc: "Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com>,
        "pgsql-docs@lists.postgresql.org" <pgsql-docs@lists.postgresql.org>
Subject: Re: Be more clear what names can be used for tables with "CREATE
 TABLE"?
In-reply-to: <13dcf5e60a2cdfd8ea68da9a2569287e342e87ab.camel@cybertec.at>
References: 
 <ZR0P278MB0920D0946509233459AF0DEFD2889@ZR0P278MB0920.CHEP278.PROD.OUTLOOK.COM>
 <13dcf5e60a2cdfd8ea68da9a2569287e342e87ab.camel@cybertec.at>
Comments: In-reply-to Laurenz Albe <laurenz.albe@cybertec.at>
	message dated "Mon, 01 Nov 2021 05:39:43 +0100"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1139297.1635782656.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Mon, 01 Nov 2021 12:04:16 -0400
Message-ID: <1139298.1635782656@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1139298.1635782656%40sss.pgh.pa.us>
Precedence: bulk

Laurenz Albe <laurenz.albe@cybertec.at> writes:
> On Sat, 2021-10-30 at 11:08 +0000, Daniel Westermann (DWE) wrote:
>> in the documentation for CREATE TABLE we have this sentence:
>> "The name of the table must be distinct from the name of any other tabl=
e, sequence, index, view, or foreign table in the same schema."
>> At least materialized views are missing:

> Technically speaking, it is "objects stored in pg_class".

We use "relation" for that concept in the code, and I believe that
that terminology is also used in the manual.  I'm inclined to propose

"The name of the table must be distinct from the name of any other
relation (table, sequence, index, view, materialized view, or foreign
table) in the same schema."

I think the existing wording might be that way because somebody
figured that "view" could subsume "materialized view".  Which
isn't an unreasonable position, but we haven't done it like that
consistently.

I don't think we need to be similarly exhaustive about enumerating
the kinds of types that there are.

			regards, tom lane