Commit9a22ea2

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 parent845626f commit9a22ea2Copy full SHA for 9a22ea2

File tree

-1

lines changed

-1

lines changed

Lines changed: 4 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -331,13 +331,16 @@ get_rel_infos(migratorContext ctx, const DbInfo dbinfo,`
`331`	`331`	`") OR ( "`
`332`	`332`	`"n.nspname = 'pg_catalog' "`
`333`	`333`	`"AND relname IN "`
`334`		`-" ('pg_largeobject', 'pg_largeobject_loid_pn_index') )) "`
	`334`	`+" ('pg_largeobject', 'pg_largeobject_loid_pn_index'%s) )) "`
`335`	`335`	`"AND relkind IN ('r','t', 'i'%s)"`
`336`	`336`	`"GROUP BY c.oid, n.nspname, c.relname, c.relfilenode,"`
`337`	`337`	`"c.reltoastrelid, t.spclocation, "`
`338`	`338`	`"n.nspname "`
`339`	`339`	`"ORDER BY n.nspname, c.relname;",`
`340`	`340`	`FirstNormalObjectId,`
	`341`	`+/* does pg_largeobject_metadata need to be migrated? */`
	`342`	`+ (GET_MAJOR_VERSION(ctx->old.major_version) <=804) ?`
	`343`	`+"" :", 'pg_largeobject_metadata', 'pg_largeobject_metadata_oid_index'",`
`341`	`344`	`/* see the comment at the top of old_8_3_create_sequence_script() */`
`342`	`345`	`(GET_MAJOR_VERSION(ctx->old.major_version) <=803) ?`
`343`	`346`	`"" :", 'S'");`

Comments

(0)