Possible Bug in pg_upgrade

Beginning with commit 002c105a0706bd1c1e939fe0f47ecdceeae6c52d
pg_upgrade will fail if there are orphaned temp tables in the current
database with the message 'old and new databases "postgres" have a
different number of relations'

On line 41 of pg_upgrade/info.c pg_upgrade checks that the number of
relations are the same but includes orphaned temp tables in the comparison.

Is this expected behavior? If so is there a more detailed error message
that can be added explain the cause of the failure? It wasn't evident
until modified pg_upgrade to show the missing oid's and recognized them
as temp tables with oid2name.

Dave Byrne

Phone: (310) 526-5000
Direct: (310) 526-5021
Email: DByrne(at)mdb(dot)com<mailto:DByrne(at)mdb(dot)com>

MDB CAPITAL GROUP LLC
Seeing Value Others Do Not, Creating Value Others Can Not.

401 Wilshire Boulevard, Suite 1020
Santa Monica, California 90401
www.mdb.com<http://www.mdb.com>

[MDB Capital Group]<http://www.mdb.com>
The IP Investment Bank