Bug in PostgreSQL JDBC Drive.

From: Raymond Chui <raymond(dot)chui(at)noaa(dot)gov>
To: pgsql-general(at)postgresql(dot)org
Subject: Bug in PostgreSQL JDBC Drive.
Date: 2001-03-16 14:43:45
Message-ID: 3AB226A1.2CE0251D@noaa.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have PostgreSQL jdbc7.0-1.2.jar JDBC drive.

I found out if a column of a table is Timestamp data type

Properties p = new Properties();
p.put("PGTZ", "GMT");

This does not take effect when you do
SELECT/UPDATE/INSERT/DELETE (QUID).
It gives me the local time zone.

This should be the same as set environment
"export PGTZ=GMT" or "setenv PGTZ GMT"
in UNIX, right?

I have to do
connection = driver.connect('myjdbcURL", p);
Statement st = connection.createStatement();
st.execute("SET TIME ZONE 'GMT'");

Well, this takes effect when I do INSERT/UPDATE
(I don't know DELETE yet). But it still does not take
effect when I do SELECT, I still get the local time
zone.

If you don't think that's is a bug, please tell me your solution(s).
Thank you very much in advance!

--Raymond

Attachment Content-Type Size
raymond.chui.vcf text/x-vcard 414 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2001-03-16 14:51:03 Re: need hint for a trigger...
Previous Message Vilson farias 2001-03-16 14:18:17 New fail in vacuum?