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
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 |
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 |