pgsql: Disallow extensions from owning the schema they are assigned to.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Disallow extensions from owning the schema they are assigned to.
Дата
Msg-id E1T1fW3-0001tV-Gn@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Disallow extensions from owning the schema they are assigned to.

This situation creates a dependency loop that confuses pg_dump and probably
other things.  Moreover, since the mental model is that the extension
"contains" schemas it owns, but "is contained in" its extschema (even
though neither is strictly true), having both true at once is confusing for
people too.  So prevent the situation from being set up.

Reported and patched by Thom Brown.  Back-patch to 9.1 where extensions
were added.

Branch
------
REL9_1_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/9e035184b0fc807297dee5e2d0a219fee21fd08a

Modified Files
--------------
src/backend/commands/extension.c |   30 +++++++++++++++++++++++++++---
1 files changed, 27 insertions(+), 3 deletions(-)


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Disallow extensions from owning the schema they are assigned to.
Следующее
От: Bruce Momjian
Дата:
Сообщение: pgsql: Document that foreign "version" and "type" values are only usefu