Possible Bug in pg_upgrade - Mailing list pgsql-hackers

From Dave Byrne
Subject Possible Bug in pg_upgrade
Date
Msg-id 4E42D23C.5010805@mdb.com
Whole thread Raw
Responses Re: Possible Bug in pg_upgrade
Re: Possible Bug in pg_upgrade
List pgsql-hackers
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@mdb.com<mailto:DByrne@mdb.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


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: "pgstat wait timeout" warnings
Next
From: Heikki Linnakangas
Date:
Subject: Re: sha1, sha2 functions into core?