Re: SQL solution for my JDBC timezone issue - Mailing list pgsql-general

From Tom Lane
Subject Re: SQL solution for my JDBC timezone issue
Date
Msg-id 12783.1424727088@sss.pgh.pa.us
Whole thread Raw
In response to Re: SQL solution for my JDBC timezone issue  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: SQL solution for my JDBC timezone issue
List pgsql-general
Dave Cramer <pg@fastcrypt.com> writes:
> Everytime you get a connection the driver will issue set timezone ...
> It does not change the default time zone for the server (AFAICS)

Hmm ... depending on exactly how you issue it, it might become the default
for the session, I think.  I seem to recall that parameter settings
included in the startup packet become session-lifespan defaults.  If you
issued the SET as a separate command then a RESET ought to undo it.

            regards, tom lane


pgsql-general by date:

Previous
From: Luca Ferrari
Date:
Subject: Re: 9.3.5 failing to compile with dtrace on FreeBSD 10.1
Next
From: Dave Cramer
Date:
Subject: Re: SQL solution for my JDBC timezone issue