Search Postgresql Archives

Re: Timezone information

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxx


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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux