From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andres Freund <andres@2ndquadrant.com>
cc: Bernhard Schrader <bernhard.schrader@innogames.de>,
	Bruce Momjian <bruce@momjian.us>, Andrew Dunstan <andrew@dunslane.net>,
	PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: [ADMIN] Problems with enums after pg_upgrade
In-reply-to: <20121218183916.GA7666@awork2.anarazel.de>
References: <50CEFE95.9040301@innogames.de>
 <20121218014137.GB29143@momjian.us>
	<50D02D13.3010004@innogames.de> <50D0914E.3040508@dunslane.net>
	<20121218162256.GA24700@momjian.us> <50D0B0AD.9010905@innogames.de>
	<11487.1355855052@sss.pgh.pa.us>
	<20121218183916.GA7666@awork2.anarazel.de>
Comments: In-reply-to Andres Freund <andres@2ndquadrant.com>
	message dated "Tue, 18 Dec 2012 19:39:16 +0100"
Date: Tue, 18 Dec 2012 14:34:33 -0500
Message-ID: <12773.1355859273@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

Andres Freund <andres@2ndquadrant.com> writes:
> On 2012-12-18 13:24:12 -0500, Tom Lane wrote:
>> Does the table being updated have any indexes on enum columns?  I'm
>> suspicious that the bogus OID is in an index page somewhere, and not
>> in the table at all.

> I already wondered whether it could be a problem caused by pg_upgrade
> not ignoring invalid indexes until recently, but I don't really see how
> it could cause an invalid oid to end up in the index.

It seems like this might indicate a flaw in our scheme for preventing
uncommitted enum values from getting into tables/indexes.  Hard to see
what though.

Bernhard, if you do identify a particular index as being the source of
the failure, that would at least tell us for sure which enum type is
at fault.  I don't suppose you would have any info about the history
of that enum type in your database?  The fact that the OID is odd
implies that it belonged to a value that was added by ALTER TYPE ADD
VALUE, but what we'd want is some context around any past uses of
that command, especially if they failed or were rolled back.

			regards, tom lane


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers