Re: Timezone information

Поиск
Список
Период
Сортировка
От Terence Ferraro
Тема Re: Timezone information
Дата
Msg-id CAEghcWCz+A-5xMR6-dOvwaw12pgbWcJ7NQySYVocMjssNdZs3w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Timezone information  (Andrew Sullivan <ajs@crankycanuck.ca>)
Ответы Re: Timezone information  (Dev Kumkar <devdas.kumkar@gmail.com>)
Список pgsql-general
Or, if you don't mind a little patching: http://pastebin.com/5AyaX2RF

That restores the pre-9.1 functionality of determining the timezone on postmaster start. As has been pointed out, their new stuff is more useful if you're shipping instances to the farthest reaches of the planet (We've only got clients in North America at the moment). You will undoubtedly need to make some modifications to patch with 9.3, but I've got hundreds of 9.2 instances in the field now that, well, just work.

Terence J. Ferraro


On Wed, Feb 19, 2014 at 5:10 PM, Andrew Sullivan <ajs@crankycanuck.ca> wrote:
On Thu, Feb 20, 2014 at 03:37:20AM +0530, Dev Kumkar wrote:
> But better is to set the TimeZone. Now haven't done anything special but
> JDBC is working with setting TimeZone and ODBC not. So what should I look
> from here now?

I think your client should set the TimeZone at connection time.
That's going to yield the most predictable behaviour for the users, I suspect.

A

--
Andrew Sullivan
ajs@crankycanuck.ca


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Timezone information
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Timezone information