Commit3a0e857

committed

Correct reference to pg_catalog.regtype in pg_upgrade query

The recursive CTE added in0ccfc28 referenced pg_catalog.regtype,without the schema part, unlike all other queries in pg_upgrade.Backpatch-to: 12

1 parent0ccfc28 commit3a0e857Copy full SHA for 3a0e857

File tree

-1

lines changed

-1

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -443,7 +443,7 @@ old_11_check_for_sql_identifier_data_type_usage(ClusterInfo *cluster)`
`443`	`443`	`res=executeQueryOrDie(conn,`
`444`	`444`	`"WITH RECURSIVE oids AS ( "`
`445`	`445`	`/* the sql_identifier type itself */`
`446`		`-"SELECT 'information_schema.sql_identifier'::regtype AS oid "`
	`446`	`+"SELECT 'information_schema.sql_identifier'::pg_catalog.regtype AS oid "`
`447`	`447`	`"UNION ALL "`
`448`	`448`	`"SELECT * FROM ( "`
`449`	`449`	`/* domains on the type */`

Comments

(0)