Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > The last patch fixes a problem where I was not migrating
> > pg_largeobject_metadata and its index for 9.0+ migrations, which of
> > course would only affect migrations to 9.1 and 9.0 to 9.0 migrations, so
> > I backpatched that to 9.0.
>
> That isn't going to work. At least not unless you start trying to force
> roles to have the same OIDs in the new installation.
Uh, don't we store the pg_shadow.usesysid in pg_largeobject_metadata?
If so I can use the CREATE ROLE ... SYSID clause when doing a binary
upgrade.
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://enterprisedb.com
+ It's impossible for everything to be true. +