Re: ERROR: Unable to locate type oid 0 in catalog...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: frbn <frbn(at)efbs-seafrigo(dot)fr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: Unable to locate type oid 0 in catalog...
Date: 2004-11-18 15:51:11
Message-ID: 16991.1100793071@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

frbn <frbn(at)efbs-seafrigo(dot)fr> writes:
> 8936960 2004-11-18 16:17:34 [31602] DEBUG: query: SELECT Oid FROM
> pg_index i WHERE i.indisprimary AND i.indrelid = 2178456572
> 8936961 2004-11-18 16:17:34 [31602] ERROR: dtoi4: integer out of range

This is a 7.1-vintage pg_dump bug --- it's not putting quotes around the
OID value. You really want to use pg_dump from a later release to dump
the data out of the old server.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-11-18 15:56:59 Re: A couple serious errors
Previous Message Mike Richards 2004-11-18 15:48:58 Re: A couple serious errors