From ec218056feb4533932bce4af820523829d831f92 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Mon, 5 Dec 2011 16:45:01 -0500 Subject: [PATCH] In pg_upgrade, allow tables using regclass to be upgraded because we preserve pg_class oids since PG 9.0. --- contrib/pg_upgrade/check.c | 2 +- doc/src/sgml/pgupgrade.sgml | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/contrib/pg_upgrade/check.c b/contrib/pg_upgrade/check.c index 720f1305a5..d5d6bedb68 100644 --- a/contrib/pg_upgrade/check.c +++ b/contrib/pg_upgrade/check.c @@ -593,7 +593,7 @@ check_for_reg_data_type_usage(migratorContext *ctx, Cluster whichCluster) " 'pg_catalog.regprocedure'::pg_catalog.regtype, " " 'pg_catalog.regoper'::pg_catalog.regtype, " " 'pg_catalog.regoperator'::pg_catalog.regtype, " - " 'pg_catalog.regclass'::pg_catalog.regtype, " +/* allow " 'pg_catalog.regclass'::pg_catalog.regtype, " */ /* regtype.oid is preserved, so 'regtype' is OK */ " 'pg_catalog.regconfig'::pg_catalog.regtype, " " 'pg_catalog.regdictionary'::pg_catalog.regtype) AND " diff --git a/doc/src/sgml/pgupgrade.sgml b/doc/src/sgml/pgupgrade.sgml index 74fba2e8e0..ae9050bdc9 100644 --- a/doc/src/sgml/pgupgrade.sgml +++ b/doc/src/sgml/pgupgrade.sgml @@ -524,7 +524,7 @@ psql --username postgres --file script.sql postgres pg_upgrade does not support migration of databases containing these reg* OID-referencing system data types: regproc, regprocedure, regoper, - regoperator, regclass, regconfig, and + regoperator, regconfig, and regdictionary. (regtype can be migrated.) -- 2.40.0