This error confuses me:
10127 Caused by: org.postgresql.util.PSQLException: ERROR: date/time
field value out of range: "2011-01-12 21:30:00.000000 +13:00:00"
The date appears to be valid,
smx3_mailreport=# select timestamp '2011-01-12 21:30:00.000000 +13:00:00';
timestamp
---------------------
2011-01-12 21:30:00
(1 row)
I cant see how any session paramater would affect this?
OSX - Postgres 8.4.4 , jdbc 8.4.702