Re: SQL solution for my JDBC timezone issue

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: SQL solution for my JDBC timezone issue
Дата
Msg-id 12783.1424727088@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: SQL solution for my JDBC timezone issue  (Dave Cramer <pg@fastcrypt.com>)
Ответы Re: SQL solution for my JDBC timezone issue  (Dave Cramer <pg@fastcrypt.com>)
Список 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 по дате отправления:

Предыдущее
От: Luca Ferrari
Дата:
Сообщение: Re: 9.3.5 failing to compile with dtrace on FreeBSD 10.1
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: SQL solution for my JDBC timezone issue