Horton

Re: Be more clear what names can be used for tables with "CREATE TABLE"?

Daniel Westermann (DWE) <daniel.westermann@dbi-services.com>

View thread View on postgr.es
From: "Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com>
To: Tom Lane <tgl@sss.pgh.pa.us>, Laurenz Albe <laurenz.albe@cybertec.at>
Cc: "pgsql-docs@lists.postgresql.org" <pgsql-docs@lists.postgresql.org>
Date: 2021-11-02T12:38:28Z
Lists: 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 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."

Works for me, +1

Regards
Daniel

Commits

  1. Doc: be more precise about conflicts between relation names.