Error: Bad Timestamp Format - Mailing list pgsql-general

From Graham Leggett
Subject Error: Bad Timestamp Format
Date
Msg-id 3B9F7C4D.899008B0@sharp.fm
Whole thread Raw
Responses Re: Error: Bad Timestamp Format
List pgsql-general
Hi all,

While moving a database installation from one machine to another, the
client app now fails with the following message:

java.rmi.RemoteException: Bad Timestamp Format at 19 in 2001-09-12
14:14:12.03-04; nested exception is:

According to the FAQ and docs, this is caused by the date format being
wrong, but the date format is the same on both installations:

vendirza=# SHOW DATESTYLE;
NOTICE:  DateStyle is ISO with US (NonEuropean) conventions

vendirza=# SHOW DATESTYLE;
NOTICE:  DateStyle is ISO with US (NonEuropean) conventions

I have checked the locale on both installations, and in both cases no
locale is set.

Can anyone suggest a solution?

I am using pgsql v7.0.3, and the database was transferred by doing a raw
transfer of the data/ directory from the first machine to the second.

Regards,
Graham
--
-----------------------------------------
minfrin@sharp.fm        "There's a moon
                    over Bourbon Street
                        tonight..."

Attachment

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Ridicolus Postgresql review
Next
From: R Talbot
Date:
Subject: Inheritance c.cities ??