Commit3302334

committed

In pg_upgrade, copy pg_largeobject_metadata and its index for 9.0+

servers because, like pg_largeobject, it is a system table whosecontents are not dumped by pg_dump --schema-only.

1 parent0857a84 commit3302334Copy full SHA for 3302334

File tree

-1

lines changed

-1

lines changed

Lines changed: 4 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -310,13 +310,16 @@ get_rel_infos(ClusterInfo cluster, DbInfo dbinfo)`
`310`	`310`	`") OR ( "`
`311`	`311`	`"n.nspname = 'pg_catalog' "`
`312`	`312`	`"AND relname IN "`
`313`		`-" ('pg_largeobject', 'pg_largeobject_loid_pn_index') )) "`
	`313`	`+" ('pg_largeobject', 'pg_largeobject_loid_pn_index'%s) )) "`
`314`	`314`	`"AND relkind IN ('r','t', 'i'%s)"`
`315`	`315`	`"GROUP BY c.oid, n.nspname, c.relname, c.relfilenode,"`
`316`	`316`	`"c.reltoastrelid, t.spclocation, "`
`317`	`317`	`"n.nspname "`
`318`	`318`	`"ORDER BY t.spclocation, n.nspname, c.relname;",`
`319`	`319`	`FirstNormalObjectId,`
	`320`	`+/* does pg_largeobject_metadata need to be migrated? */`
	`321`	`+ (GET_MAJOR_VERSION(old_cluster.major_version) <=804) ?`
	`322`	`+"" :", 'pg_largeobject_metadata', 'pg_largeobject_metadata_oid_index'",`
`320`	`323`	`/* see the comment at the top of old_8_3_create_sequence_script() */`
`321`	`324`	`(GET_MAJOR_VERSION(old_cluster.major_version) <=803) ?`
`322`	`325`	`"" :", 'S'");`

Comments

(0)