Re: ERROR: Unable to locate type oid 0 in catalog... - Mailing list pgsql-general

From Tom Lane
Subject Re: ERROR: Unable to locate type oid 0 in catalog...
Date
Msg-id 16991.1100793071@sss.pgh.pa.us
Whole thread Raw
In response to Re: ERROR: Unable to locate type oid 0 in catalog...  (frbn <frbn@efbs-seafrigo.fr>)
List pgsql-general
frbn <frbn@efbs-seafrigo.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

pgsql-general by date:

Previous
From: Mike Richards
Date:
Subject: Re: A couple serious errors
Next
From: Tom Lane
Date:
Subject: Re: A couple serious errors