Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TkYfZ-0007gJ-At for pgsql-admin@arkaria.postgresql.org; Mon, 17 Dec 2012 11:15:37 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TkYfY-0007KX-3h for pgsql-admin@arkaria.postgresql.org; Mon, 17 Dec 2012 11:15:36 +0000 Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TkYfX-0007KK-DJ for pgsql-admin@postgresql.org; Mon, 17 Dec 2012 11:15:35 +0000 Received: from tx2ehsobe004.messaging.microsoft.com ([65.55.88.14] helo=tx2outboundpool.messaging.microsoft.com) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TkYfR-0005BN-V7 for pgsql-admin@postgresql.org; Mon, 17 Dec 2012 11:15:34 +0000 Received: from mail81-tx2-R.bigfish.com (10.9.14.250) by TX2EHSOBE004.bigfish.com (10.9.40.24) with Microsoft SMTP Server id 14.1.225.23; Mon, 17 Dec 2012 11:15:25 +0000 Received: from mail81-tx2 (localhost [127.0.0.1]) by mail81-tx2-R.bigfish.com (Postfix) with ESMTP id 23F596032C for ; Mon, 17 Dec 2012 11:15:24 +0000 (UTC) X-Forefront-Antispam-Report: CIP:157.56.252.133; KIP:(null); UIP:(null); IPV:NLI; H:DBXPRD0310HT003.eurprd03.prod.outlook.com; RD:none; EFVD:NLI X-SpamScore: -1 X-BigFish: PS-1(zzc89bh1443Izz1d74h1de0h1d18h1202h1e76h1d1ah1d2ahzz17326ah8275bh1954cbhz2fh2a8h668h839h946hd25he5bhf0ah1288h12a5h12a9h12bdh137ah13b6h1441h1504h1537h153bh162dh1631h1758h1765h1155h) Received-SPF: pass (mail81-tx2: domain of innogames.de designates 157.56.252.133 as permitted sender) client-ip=157.56.252.133; envelope-from=bernhrad.schrader@innogames.de; helo=DBXPRD0310HT003.eurprd03.prod.outlook.com ; .outlook.com ; Received: from mail81-tx2 (localhost.localdomain [127.0.0.1]) by mail81-tx2 (MessageSwitch) id 1355742883634325_22451; Mon, 17 Dec 2012 11:14:43 +0000 (UTC) Received: from TX2EHSMHS041.bigfish.com (unknown [10.9.14.247]) by mail81-tx2.bigfish.com (Postfix) with ESMTP id 8D97B32004E for ; Mon, 17 Dec 2012 11:14:43 +0000 (UTC) Received: from DBXPRD0310HT003.eurprd03.prod.outlook.com (157.56.252.133) by TX2EHSMHS041.bigfish.com (10.9.99.141) with Microsoft SMTP Server (TLS) id 14.1.225.23; Mon, 17 Dec 2012 11:14:43 +0000 Received: from [172.16.22.146] (212.48.107.10) by pod51013.outlook.com (10.255.65.166) with Microsoft SMTP Server (TLS) id 14.16.245.2; Mon, 17 Dec 2012 11:14:30 +0000 Message-ID: <50CEFE95.9040301@innogames.de> Date: Mon, 17 Dec 2012 12:14:29 +0100 From: Bernhard Schrader User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/17.0 Thunderbird/17.0 MIME-Version: 1.0 To: Subject: Problems with enums after pg_upgrade Content-Type: text/plain; charset="windows-1252"; format=flowed X-Originating-IP: [212.48.107.10] Content-Transfer-Encoding: quoted-printable X-OriginatorOrg: innogames.de X-Pg-Spam-Score: -4.2 (----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Hello together, last thursday I upgraded one of our 9.0.6 postgresql servers to 9.2.2=20 with pg_upgrade. So far everything seemed to work but we now discover=20 problems with the enum types. If we run one specific query it breaks all=20 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=20 in pg_enum. How could i solve this problem? should we regenerate all enums? or what=20 could we do? Hopefully anyone has a clue, google doesn't seem to be the ressource for=20 this problem. thanks in advance Bernhard Schrader --=20 Bernhard Schrader System Administration InnoGames GmbH Harburger Schlo=DFstra=DFe 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 =96 bernhard.schrader@innogames.de --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin