pgsql: Properly schema-qualify additional object types ingetObjectDesc
От | Tom Lane |
---|---|
Тема | pgsql: Properly schema-qualify additional object types ingetObjectDesc |
Дата | |
Msg-id | E1fLsma-0007u0-9Q@gemulon.postgresql.org обсуждение исходный текст |
Список | pgsql-committers |
Properly schema-qualify additional object types in getObjectDescription(). Collations, conversions, extended statistics objects (in >= v10), and all four types of text search objects have schema-qualified names. getObjectDescription() ignored that and would emit just the base name of the object, potentially producing wrong or at least highly misleading output. Fix it to add the schema name whenever the object is not "visible" in the current search path, as is the rule for other schema-qualifiable object types. Although in common situations the output won't change, this seems to me (tgl) to be a bug worthy of back-patching, hence do so. Kyotaro Horiguchi, per a complaint from me Discussion: https://postgr.es/m/20180522.182020.114074746.horiguchi.kyotaro@lab.ntt.co.jp Branch ------ REL9_6_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/3d3165210dccff489e3082b96f4b5c0d4ade37ff Modified Files -------------- src/backend/catalog/objectaddress.c | 76 ++++++++++++++++++++++++++--- src/test/regress/expected/alter_generic.out | 10 ++-- src/test/regress/expected/alter_table.out | 10 ++-- 3 files changed, 80 insertions(+), 16 deletions(-)
В списке pgsql-committers по дате отправления: