From: Bruce Momjian <bruce@momjian.us>
To: Bernhard Schrader <bernhard.schrader@innogames.de>
Cc: PostgreSQL-development <pgsql-hackers@postgreSQL.org>
Subject: Re: [ADMIN] Problems with enums after pg_upgrade
Date: Mon, 17 Dec 2012 21:10:23 -0500
Message-ID: <20121218021023.GC29143@momjian.us> (raw)
In-Reply-To: <50CEFE95.9040301@innogames.de>
References: <50CEFE95.9040301@innogames.de>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
On Mon, Dec 17, 2012 at 12:14:29PM +0100, Bernhard Schrader wrote:
> Hello together,
>
> last thursday I upgraded one of our 9.0.6 postgresql servers to
> 9.2.2 with pg_upgrade. So far everything seemed to work but we now
> discover problems with the enum types. If we run one specific query
> it breaks all time with such an error message:
>
> ERROR: invalid internal value for enum: 520251
>
> if this number should represent the enumtypid it is not existing
> anymore in pg_enum.
>
> How could i solve this problem? should we regenerate all enums? or
> what could we do?
> Hopefully anyone has a clue, google doesn't seem to be the ressource
> for this problem.
Can anyone suggest why enum upgrade is failing for this user? What
should he be checking for?
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bruce@momjian.us, bernhard.schrader@innogames.de, pgsql-hackers@postgreSQL.org
Subject: Re: [ADMIN] Problems with enums after pg_upgrade
In-Reply-To: <20121218021023.GC29143@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox