diff options
| author | Tomas Vondra | 2019-10-14 22:25:04 +0000 |
|---|---|---|
| committer | Tomas Vondra | 2019-10-14 22:25:04 +0000 |
| commit | 3a0e85739490e5cd50e5eba382ae3c9cc3bc2fca (patch) | |
| tree | ed6754af2afe6a4515b284b6b9424df7d6e32bc0 | |
| parent | 0ccfc2822366f92c61cba96541d1c64d2b8b2086 (diff) | |
Correct reference to pg_catalog.regtype in pg_upgrade query
The recursive CTE added in 0ccfc28223 referenced pg_catalog.regtype,
without the schema part, unlike all other queries in pg_upgrade.
Backpatch-to: 12
| -rw-r--r-- | src/bin/pg_upgrade/version.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/bin/pg_upgrade/version.c b/src/bin/pg_upgrade/version.c index f3fd8fa2737..8375a46454a 100644 --- a/src/bin/pg_upgrade/version.c +++ b/src/bin/pg_upgrade/version.c @@ -443,7 +443,7 @@ old_11_check_for_sql_identifier_data_type_usage(ClusterInfo *cluster) res = executeQueryOrDie(conn, "WITH RECURSIVE oids AS ( " /* the sql_identifier type itself */ - " SELECT 'information_schema.sql_identifier'::regtype AS oid " + " SELECT 'information_schema.sql_identifier'::pg_catalog.regtype AS oid " " UNION ALL " " SELECT * FROM ( " /* domains on the type */ |