Graham,
I am guessing from the error that you are using JDBC as your client.
This looks like a known issue with the 7.0 jdbc driver. Have your tried
the 7.1 jdbc driver? (as long as you don't use the DatabaseMetadata
object too much, the 7.1 driver should work fine against a 7.0 database).
Also you might want to look at this message from the archives:
http://archives.postgresql.org/pgsql-jdbc/2001-03/msg00168.php
Which discusses this bug.
thanks,
--Barry
Graham Leggett wrote:
> 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
>
>
> ------------------------------------------------------------------------
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>