Re: PG_DUMP / PG_RESTORE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: efesar(at)nmia(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: PG_DUMP / PG_RESTORE
Date: 2002-08-07 03:21:14
Message-ID: 12088.1028690474@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"the kay (efesar)" <efesar(at)nmia(dot)com> writes:
> msg from pg_restore

> Archiver(db): Could not execute query. Code = 7. Explanation from backend:
> 'ERROR: parser: parse error at or near "9223372036854775807"

Not very helpful (we really oughta fix pg_restore to report the failing
query, not only the backend's message). Please turn on query logging
in postgresql.conf, try the restore, and send along the last few queries
as seen in the postmaster log.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Adam Walczykiewicz 2002-08-07 05:42:30 can't create plpgsql language on SCO 5
Previous Message Pavel Stehule 2002-08-06 21:37:07 Re: mistakes in postgresql-snapshots (7.3)