Re: Wrong note in the information schema section?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Wrong note in the information schema section?
Дата
Msg-id CAKFQuwYEJc4nF+=4J8d6z8DYs=b4zp-f9q9S5psReNM+OZ3N6A@mail.gmail.com
обсуждение исходный текст
Ответ на Wrong note in the information schema section?  ("Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com>)
Ответы Re: Wrong note in the information schema section?  ("Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com>)
Список pgsql-docs
Дерево обсуждения
On Mon, Aug 30, 2021 at 5:51 AM Daniel Westermann (DWE) <daniel.westermann@dbi-services.com> wrote:

we have this note in the information schema section, e.g. in https://www.postgresql.org/docs/current/information-schema.html

..."This is because the SQL standard requires constraint names to be unique within a schema, but PostgreSQL does not enforce this restriction."
...
PostgreSQL does enforce unique constraint names in a schema:

[...]
... but I guess this is not what the notes is supposed to tell me, correct?


Practically speaking there must be some level of scope where a duplicate name error can occur.  All the docs say is that the schema scope is not it.  You've demonstrated that it is the table scope where duplication of names is detected.

David J.

В списке pgsql-docs по дате отправления:

Предыдущее
От: "Daniel Westermann (DWE)"
Дата:
Сообщение: Wrong note in the information schema section?
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: I came here to determine how much storage a boolean variable uses