Hi all,
I'm using PostgreSQL 8.4.4, jdbc driver postgresql-8.4-701.jdbc4.jar and last snapshot of Squirrel.

Sending the following sql:
select current_time, current_date, current_timestamp as timestamptz, localtime, localtimestamp;

i get
timetz        date                timestamptz                        time                timestamp
08:59:29        2010-05-18        2010-05-18 09:59:29.373        09:59:29        2010-05-18 09:59:29.373

and here's what it should be:
     timetz      |    date    |        timestamptz         |     time     |   timestamp
-----------------+------------+----------------------------+--------------+-------------------------
 09:59:31.092+02 | 2010-05-18 | 2010-05-18 09:59:31.092+02 | 09:59:31.092 | 2010-05-18 09:59:31.092

The time zone information is missing from both timetz and timestamptz and timetz time value is one hour behind what it should be (possibly it's missing the daylight saving time).

I cannot find any config option nor any driver property to change this behavior, is that a bug?

Regards,
Gabriele