Re: Timezone information - Mailing list pgsql-general

From Terence Ferraro
Subject Re: Timezone information
Date
Msg-id CAEghcWCz+A-5xMR6-dOvwaw12pgbWcJ7NQySYVocMjssNdZs3w@mail.gmail.com
Whole thread Raw
In response to Re: Timezone information  (Andrew Sullivan <ajs@crankycanuck.ca>)
Responses Re: Timezone information  (Dev Kumkar <devdas.kumkar@gmail.com>)
List 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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Timezone information
Next
From: Tom Lane
Date:
Subject: Re: Timezone information