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"?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: PG Doc comments form
Дата:
Сообщение: initdb: nothing about template0
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: [PATCH] fix ICU explorer link in locale documentation