<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">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.<br>
<br>
Sean<br>
<br>
On 13-09-10 02:17 PM, Sean Hogan wrote:<br>
</div>
<blockquote cite="mid:522F4D2F.2070408@compusult.net" type="cite">Hi,
<br>
<br>
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).
<br>
<br>
$ psql -h psql-vip -U postgres
<br>
postgres=# create table t1 (tm timestamp with time zone);
<br>
CREATE TABLE
<br>
postgres=# insert into t1 (tm) values (current_timestamp);
<br>
INSERT 0 1
<br>
postgres=# select * from t1;
<br>
tm
<br>
----------------------------------
<br>
2013-09-10 13:41:05.648345-02:30
<br>
(1 row)
<br>
<br>
$ date
<br>
Tue Sep 10 14:08:13 NDT 2013
<br>
<br>
If I do the exact same test against the real PostgreSQL backend,
the column contains the correct time:
<br>
<br>
$ psql -h psql-vm1 -p 5433 -U postgres
<br>
postgres=# create table t2 (tm timestamp with time zone);
<br>
CREATE TABLE
<br>
postgres=# insert into t2 (tm) values (current_timestamp);
<br>
INSERT 0 1
<br>
postgres=# select * from t2;
<br>
tm
<br>
----------------------------------
<br>
2013-09-10 14:15:34.205086-02:30
<br>
(1 row)
<br>
<br>
$ date
<br>
Tue Sep 10 14:15:39 NDT 2013
<br>
<br>
<br>
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.
<br>
<br>
Thanks,
<br>
Sean
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
pgpool-general mailing list
<a class="moz-txt-link-abbreviated" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a>
<a class="moz-txt-link-freetext" href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a>
</pre>
</blockquote>
<br>
</body>
</html>