Skip to content

Commit ec21805

Browse files
committed
In pg_upgrade, allow tables using regclass to be upgraded because we
preserve pg_class oids since PG 9.0.
1 parent 621fd4d commit ec21805

File tree

2 files changed

+2
-2
lines changed

2 files changed

+2
-2
lines changed

contrib/pg_upgrade/check.c

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -593,7 +593,7 @@ check_for_reg_data_type_usage(migratorContext *ctx, Cluster whichCluster)
593593
" 'pg_catalog.regprocedure'::pg_catalog.regtype, "
594594
" 'pg_catalog.regoper'::pg_catalog.regtype, "
595595
" 'pg_catalog.regoperator'::pg_catalog.regtype, "
596-
" 'pg_catalog.regclass'::pg_catalog.regtype, "
596+
/* allow " 'pg_catalog.regclass'::pg_catalog.regtype, " */
597597
/* regtype.oid is preserved, so 'regtype' is OK */
598598
" 'pg_catalog.regconfig'::pg_catalog.regtype, "
599599
" 'pg_catalog.regdictionary'::pg_catalog.regtype) AND "

doc/src/sgml/pgupgrade.sgml

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -524,7 +524,7 @@ psql --username postgres --file script.sql postgres
524524
<application>pg_upgrade</> does not support migration of databases
525525
containing these <type>reg*</> OID-referencing system data types:
526526
<type>regproc</>, <type>regprocedure</>, <type>regoper</>,
527-
<type>regoperator</>, <type>regclass</>, <type>regconfig</>, and
527+
<type>regoperator</>, <type>regconfig</>, and
528528
<type>regdictionary</>. (<type>regtype</> can be migrated.)
529529
</para>
530530

0 commit comments

Comments
 (0)