Re: Be more clear what names can be used for tables with "CREATE TABLE"?
От | Daniel Westermann (DWE) |
---|---|
Тема | Re: Be more clear what names can be used for tables with "CREATE TABLE"? |
Дата | |
Msg-id | ZR0P278MB09206419D06979743FB411F0D28B9@ZR0P278MB0920.CHEP278.PROD.OUTLOOK.COM обсуждение исходный текст |
Ответ на | Re: Be more clear what names can be used for tables with "CREATE TABLE"? (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Be more clear what names can be used for tables with "CREATE TABLE"?
|
Список | 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 по дате отправления: