Tom Lane wrote: > Bruce Momjian <br...@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 <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers