| 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: | Whole Thread | Raw Message | 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..."
| 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 |