(unnamed)

text/plain

Download

commit 3302334b48e2be6eb2c01dcf500363dbd4f22e59
Author: Bruce Momjian <bruce@momjian.us>
Date:   Tue Jan 4 23:35:49 2011 -0500

    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.

diff --git a/contrib/pg_upgrade/info.c b/contrib/pg_upgrade/info.c
index 9e69ecd..8d566c0 100644
*** /tmp/I8SAQe_info.c	Wed Jan  5 09:05:05 2011
--- /tmp/IOoIFc_info.c	Wed Jan  5 09:05:05 2011
*************** get_rel_infos(ClusterInfo *cluster, DbIn
*** 310,322 ****
  			 "	) OR ( "
  			 "	n.nspname = 'pg_catalog' "
  			 "	AND relname IN "
! 			 "        ('pg_largeobject', 'pg_largeobject_loid_pn_index') )) "
  			 "	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,
  	/* see the comment at the top of old_8_3_create_sequence_script() */
  			 (GET_MAJOR_VERSION(old_cluster.major_version) <= 803) ?
  			 "" : ", 'S'");
--- 310,325 ----
  			 "	) OR ( "
  			 "	n.nspname = 'pg_catalog' "
  			 "	AND relname IN "
! 			 "        ('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'");