Problems with enums after pg_upgrade

From: Bernhard Schrader <bernhard(dot)schrader(at)innogames(dot)de>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Problems with enums after pg_upgrade
Date: 2012-12-17 11:14:29
Message-ID: 50CEFE95.9040301@innogames.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

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(dot)schrader(at)innogames(dot)de

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Shams Khan 2012-12-17 11:55:51 Re: PostgreSQL Performance Tuning / Postgresql.conf and on OS Level
Previous Message Kevin Grittner 2012-12-16 20:37:02 Re: ERROR: index row size exceeds maximum 2712 for index

Browse pgsql-hackers by date

  From Date Subject
Next Message Groshev Andrey 2012-12-17 11:33:40 trouble with pg_upgrade 9.0 -> 9.1
Previous Message Jeff Davis 2012-12-17 10:42:20 Re: SP-GiST for ranges based on 2d-mapping and quad-tree