From 98fbce09316525e1da5a5c94ea8d75ead69669fb Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Mon, 5 Dec 2011 16:45:19 -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 419628c3a4..7aa5c28c47 100644 --- a/contrib/pg_upgrade/check.c +++ b/contrib/pg_upgrade/check.c @@ -686,7 +686,7 @@ check_for_reg_data_type_usage(ClusterInfo *cluster) " '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 3a6dbfd65a..cb4396aa01 100644 --- a/doc/src/sgml/pgupgrade.sgml +++ b/doc/src/sgml/pgupgrade.sgml @@ -541,7 +541,7 @@ psql --username postgres --file script.sql postgres pg_upgrade does not support upgrading of databases containing these reg* OID-referencing system data types: regproc, regprocedure, regoper, - regoperator, regclass, regconfig, and + regoperator, regconfig, and regdictionary. (regtype can be upgraded.) -- 2.40.0