On 09/30/2017 03:32 PM, Tom Lane wrote: > Andrew Dunstan <andrew.duns...@2ndquadrant.com> writes: >> We seem to have caused a problem with pg_upgrade :-( >> pg_restore: [archiver (db)] could not execute query: ERROR: pg_type >> array OID value not set when in binary upgrade mode >> Here we're upgrading from 9.2 to HEAD. Of course, there isn't an array >> oid for the domain in 9.2. > Hmm. That's pretty annoying. We could certainly go ahead and assign > some unused type OID to the new array type, but the receiving backend > can't really do that, since it doesn't know which type OIDs will be > assigned later in the dump file. > > Maybe we could put the burden on pg_upgrade (pg_dump --binary-upgrade) > to select an OID that's not in use in the source database. > >
Yes, I think we'll have to do something like that. cheers andrew -- Andrew Dunstan https://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
