pg_dumpall: query failed:

From: gnotari(at)linkgroup(dot)it
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: pg_dumpall: query failed:
Date: 2003-07-29 08:13:00
Message-ID: OFD3E96C42.E3B0BBFA-ONC1256D72.002CE564@linkgroup.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have this problem with a nightly script that dumps the db:

pg_dumpall: query failed: ERROR: Unable to convert abstime 'invalid' to
timestamp
pg_dumpall: query was: SELECT usename, usesysid, passwd, usecreatedb,
usesuper, CAST(valuntil AS timestamp) FROM pg_shadow WHERE usesysid <>
(SELECT datdba FROM pg_database WHERE datname = 'template0');

Postgres version is 7.3.2.

Any hints?

ciao
Guido

Responses

Browse pgsql-general by date

  From Date Subject
Next Message gnotari 2003-07-29 08:28:52 Batch processing
Previous Message Stephan Szabo 2003-07-29 05:50:30 Re: CREATE TABLE with REFERENCE