| From: | "Daniel Westermann (DWE)" <daniel(dot)westermann(at)dbi-services(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
| Cc: | "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Be more clear what names can be used for tables with "CREATE TABLE"? |
| Date: | 2021-11-02 12:38:28 |
| Message-ID: | ZR0P278MB09206419D06979743FB411F0D28B9@ZR0P278MB0920.CHEP278.PROD.OUTLOOK.COM |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
>Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2021-11-02 13:31:29 | Re: [PATCH] fix ICU explorer link in locale documentation |
| Previous Message | PG Doc comments form | 2021-11-02 07:22:31 | initdb: nothing about template0 |