diff options
| author | Bruce Momjian <bruce@momjian.us> | 2011-01-04 23:35:49 -0500 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2011-01-04 23:35:49 -0500 |
| commit | 3302334b48e2be6eb2c01dcf500363dbd4f22e59 (patch) | |
| tree | 00c537ac2492dc64abfef1456dc34c356a7e53f3 | |
| parent | 0857a8449826867711a9c1f99088bd13731ac192 (diff) | |
| download | postgresql-3302334b48e2be6eb2c01dcf500363dbd4f22e59.tar.gz | |
In pg_upgrade, copy pg_largeobject_metadata and its index for 9.0+
servers because, like pg_largeobject, it is a system table whose
contents are not dumped by pg_dump --schema-only.
| -rw-r--r-- | contrib/pg_upgrade/info.c | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/contrib/pg_upgrade/info.c b/contrib/pg_upgrade/info.c index 9e69ecd1f8..8d566c0b2d 100644 --- a/contrib/pg_upgrade/info.c +++ b/contrib/pg_upgrade/info.c @@ -310,13 +310,16 @@ get_rel_infos(ClusterInfo *cluster, DbInfo *dbinfo) " ) OR ( " " n.nspname = 'pg_catalog' " " AND relname IN " - " ('pg_largeobject', 'pg_largeobject_loid_pn_index') )) " + " ('pg_largeobject', 'pg_largeobject_loid_pn_index'%s) )) " " AND relkind IN ('r','t', 'i'%s)" "GROUP BY c.oid, n.nspname, c.relname, c.relfilenode," " c.reltoastrelid, t.spclocation, " " n.nspname " "ORDER BY t.spclocation, n.nspname, c.relname;", FirstNormalObjectId, + /* does pg_largeobject_metadata need to be migrated? */ + (GET_MAJOR_VERSION(old_cluster.major_version) <= 804) ? + "" : ", 'pg_largeobject_metadata', 'pg_largeobject_metadata_oid_index'", /* see the comment at the top of old_8_3_create_sequence_script() */ (GET_MAJOR_VERSION(old_cluster.major_version) <= 803) ? "" : ", 'S'"); |