Re: PG_DUMP / PG_RESTORE - Mailing list pgsql-bugs

From Tom Lane
Subject Re: PG_DUMP / PG_RESTORE
Date
Msg-id 12088.1028690474@sss.pgh.pa.us
Whole thread Raw
In response to PG_DUMP / PG_RESTORE  ("the kay (efesar)" <efesar@nmia.com>)
List pgsql-bugs
"the kay (efesar)" <efesar@nmia.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

pgsql-bugs by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: mistakes in postgresql-snapshots (7.3)
Next
From: Adam Walczykiewicz
Date:
Subject: can't create plpgsql language on SCO 5 - postgresql 7.2.1 from Skunkware