Skip site navigation (1) Skip section navigation (2)

Possible Bug in pg_upgrade

From: Dave Byrne <dbyrne(at)mdb(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Possible Bug in pg_upgrade
Date: 2011-08-10 18:47:24
Message-ID: 4E42D23C.5010805@mdb.com (view raw or flat)
Thread:
Lists: 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(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

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2011-08-10 18:50:00
Subject: Re: SHOW command always returns text field
Previous:From: Peter EisentrautDate: 2011-08-10 18:45:56
Subject: Re: sha1, sha2 functions into core?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group