Error: Bad Timestamp Format

From: Graham Leggett <minfrin(at)sharp(dot)fm>
To: pgsql-general(at)postgresql(dot)org
Subject: Error: Bad Timestamp Format
Date: 2001-09-12 15:16:29
Message-ID: 3B9F7C4D.899008B0@sharp.fm
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sharp(dot)fm "There's a moon
over Bourbon Street
tonight..."

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Justin Clift 2001-09-12 15:18:30 Re: Ridicolus Postgresql review
Previous Message Marek Wróbel 2001-09-12 14:47:57 postgres + odbc + delphi + largeobjects