diff options
| author | Tomas Vondra <tomas.vondra@postgresql.org> | 2019-10-15 00:25:04 +0200 |
|---|---|---|
| committer | Tomas Vondra <tomas.vondra@postgresql.org> | 2019-10-15 00:35:51 +0200 |
| commit | 702fd3b717f59b1fada3742f2f0eb529717fc3f9 (patch) | |
| tree | ccc88a33ade33c2bf038a55e9f5f26d37ea35a3c /src | |
| parent | eaf900e842ab0c8a03f23a2eda6a872eb9fce1c7 (diff) | |
| download | postgresql-702fd3b717f59b1fada3742f2f0eb529717fc3f9.tar.gz postgresql-702fd3b717f59b1fada3742f2f0eb529717fc3f9.zip | |
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
Diffstat (limited to 'src')
| -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 60a1025c3ec..701b17740d3 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 */ |