Re: Timezone information

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(at)crankycanuck(dot)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(at)crankycanuck(dot)ca
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>