[pgpool-general: 2115] Re: possible timezone handling issue

[Sean Hogan]

(Sorry for so many replies to my own message.)

I should also have said that "select current_timestamp;" gives the 
correct response through pgpool-II.

Sean


On 13-09-10 02:20 PM, Sean Hogan wrote:
> I should have said, this is version 3.3.1 running against a pair of 
> PostgreSQL back ends, all on CentOS 6.  The various timezones are all 
> set correctly.
>
> Sean
>
> On 13-09-10 02:17 PM, Sean Hogan wrote:
>> Hi,
>>
>> I happen to live in a 30 minute time zone (GMT-2:30 at the moment). 
>> Today I got a user report complaining that when they insert 
>> current_timestamp into a "timestamp with time zone" column, the 
>> column ends up containing a time that is 30 minutes too early (but 
>> with the correct timezone).
>>
>> $ psql -h psql-vip -U postgres
>> postgres=# create table t1 (tm timestamp with time zone);
>> CREATE TABLE
>> postgres=# insert into t1 (tm) values (current_timestamp);
>> INSERT 0 1
>> postgres=# select * from t1;
>>                 tm
>> ----------------------------------
>>  2013-09-10 13:41:05.648345-02:30
>> (1 row)
>>
>> $ date
>> Tue Sep 10 14:08:13 NDT 2013
>>
>> If I do the exact same test against the real PostgreSQL backend, the 
>> column contains the correct time:
>>
>> $ psql -h psql-vm1 -p 5433 -U postgres
>> postgres=# create table t2 (tm timestamp with time zone);
>> CREATE TABLE
>> postgres=# insert into t2 (tm) values (current_timestamp);
>> INSERT 0 1
>> postgres=# select * from t2;
>>                 tm
>> ----------------------------------
>>  2013-09-10 14:15:34.205086-02:30
>> (1 row)
>>
>> $ date
>> Tue Sep 10 14:15:39 NDT 2013
>>
>>
>> Does pgpool-II have a limitation in this area?  It's an enormous 
>> problem for me because our application's scheduler records activity 
>> times this way.
>>
>> Thanks,
>> Sean
>>
>>
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130910/0f2ecd3b/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sean.vcf
Type: text/x-vcard
Size: 275 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130910/0f2ecd3b/attachment.vcf>