Re: Be more clear what names can be used for tables with "CREATE TABLE"? - Mailing list pgsql-docs

From Daniel Westermann (DWE)
Subject Re: Be more clear what names can be used for tables with "CREATE TABLE"?
Date
Msg-id ZR0P278MB09206419D06979743FB411F0D28B9@ZR0P278MB0920.CHEP278.PROD.OUTLOOK.COM
Whole thread Raw
In response to Re: Be more clear what names can be used for tables with "CREATE TABLE"?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Be more clear what names can be used for tables with "CREATE TABLE"?
List pgsql-docs
>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 table, sequence, index, view, or foreign table
inthe 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."

Works for me, +1

Regards
Daniel


pgsql-docs by date:

Previous
From: PG Doc comments form
Date:
Subject: initdb: nothing about template0
Next
From: Laurenz Albe
Date:
Subject: Re: [PATCH] fix ICU explorer link in locale documentation