Regarding my last email. I have found the issue. Windows 2K is reporting the timezine as GMTDT (GMT, Dublin time... I think) and I don't believe Postgresql can understand this.
See the following code segments:
mcauleyt=# select timeofday();
timeofday
---------------------------------------
Fri Jul 25 10:38:13.056614 2003 GMTST
(1 row)mcauleyt=# select substr(timeofday(), 1, 35);
substr
-------------------------------------
Fri Jul 25 10:38:16.952614 2003 GMT
(1 row)mcauleyt=# select timeofday()::timestamp;
ERROR: Bad timestamp external representation 'Fri Jul 25 10:38:51.410614 2003 GMTST'
mcauleyt=# select substr(timeofday(), 1, 35)::timestamp;
substr
----------------------------
2003-07-25 10:38:57.918614
(1 row)
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
