pgsql: Require the schema qualification in pg_temp.type_name(arg).

Require the schema qualification in pg_temp.type_name(arg).

Commit aa27977fe21a7dfa4da4376ad66ae37cb8f0d0b5 introduced this
restriction for pg_temp.function_name(arg); do likewise for types
created in temporary schemas. Programs that this breaks should add
"pg_temp." schema qualification or switch to arg::type_name syntax.
Back-patch to 9.4 (all supported versions).

Reviewed by Tom Lane. Reported by Tom Lane.

Security: CVE-2019-10208

Branch
------
REL9_4_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/86737438b2449832371ca8295f8af48630d8481e

Modified Files
--------------
doc/src/sgml/config.sgml | 4 ++++
src/backend/catalog/namespace.c | 15 ++++++++++++++-
src/backend/parser/parse_func.c | 7 ++++++-
src/backend/parser/parse_type.c | 24 +++++++++++++++++++++---
src/backend/utils/adt/ruleutils.c | 8 ++++++++
src/include/catalog/namespace.h | 1 +
src/include/parser/parse_type.h | 3 +++
src/test/regress/expected/temp.out | 15 +++++++++++++++
src/test/regress/sql/temp.sql | 11 +++++++++++
9 files changed, 83 insertions(+), 5 deletions(-)