Re: [GENERAL] psql error while restoring database: unrecognized node type: 655

2007-07-16 Thread Tom Lane
Jeff Ross <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Hmm [ pokes around a bit... ] Do you perhaps have a higher debug >> verbosity level on this machine than the others? I can't immediately >> think of a reason why anything would be trying to print an untransformed >> NULL constant, but it

Re: [GENERAL] psql error while restoring database: unrecognized node type: 655

2007-07-16 Thread Jeff Ross
Tom Lane wrote: Jeff Ross <[EMAIL PROTECTED]> writes: Tom Lane wrote: Hmm. Can you try that with \set VERBOSITY verbose so we can determine where the error is being thrown from? psql:/tmp/people.sql:79: ERROR: XX000: unrecognized node type: 655 LOCATION: _outValue, outfuncs.c:1707 Hmm [

Re: [GENERAL] psql error while restoring database: unrecognized node type: 655

2007-07-16 Thread Jeff Ross
Tom Lane wrote: Jeff Ross <[EMAIL PROTECTED]> 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 t

Re: [GENERAL] psql error while restoring database: unrecognized node type: 655

2007-07-16 Thread Tom Lane
Jeff Ross <[EMAIL PROTECTED]> 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? > The interesting thing is

[GENERAL] psql error while restoring database: unrecognized node type: 655

2007-07-16 Thread Jeff Ross
I'm attempting to dump and restore an 8.2.4 database to another (same architecture) machine also running 8.2.4 with a freshly initialized database. I'm using this script to generate the pg_dump file: #!/bin/sh DATE=`date +%Y%m%d%H%M%S` #dump the live wykids database /usr/local/bin/pg_dumpall