From: Bernhard Schrader <bernhard.schrader@innogames.de>
To: pgsql-admin@postgresql.org
Subject: Problems with enums after pg_upgrade
Date: Mon, 17 Dec 2012 12:14:29 +0100
Message-ID: <50CEFE95.9040301@innogames.de> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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.
thanks in advance
Bernhard Schrader
--
Bernhard Schrader
System Administration
InnoGames GmbH
Harburger Schloßstraße 28 (Channel 4) - 21079 Hamburg - Germany
Tel +49 40 7889335-53
Fax +49 40 7889335-22
Managing Directors: Hendrik Klindworth, Eike Klindworth, Michael Zillmer
VAT-ID: DE264068907 Amtsgericht Hamburg, HRB 108973
http://www.innogames.com – bernhard.schrader@innogames.de
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: bernhard.schrader@innogames.de
Subject: Re: Problems with enums after pg_upgrade
In-Reply-To: <50CEFE95.9040301@innogames.de>
* 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