Re: psql error while restoring database: unrecognized node type: 655

Tom Lane wrote:
> Jeff Ross <jross(at)wykids(dot)org> writes:
>> When psql begins loading this file, it throws the error:
>
>> psql:/tmp/people.sql:79: ERROR: unrecognized node type: 655
>
> Hmm. Can you try that with \set VERBOSITY verbose so we can determine
> where the error is being thrown from?
>

Using the same dump file as before, but with verbosity on:

psql:/tmp/people.sql:79: ERROR: XX000: unrecognized node type: 655
LOCATION: _outValue, outfuncs.c:1707
psql:/tmp/people.sql:82: ERROR: 42P01: relation "public.people" does
not exist
LOCATION: RangeVarGetRelid, namespace.c:216

>> The interesting thing is that this exact process works just fine to a
>> third machine also running 8.2.4
>
> The example doesn't fail for me, either.
>
> We've occasionally seen messages of this type from poorly-done local
> modifications to the backend. How did you come by the postgres
> executables you're using on the problem machine?
>

I installed the latest package from the OpenBSD snapshots. The other
machines are also using OpenBSD package installations.

> regards, tom lane

Thanks,

Jeff