<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">(Sorry for so many replies to my own
message.)<br>
<br>
I should also have said that "select current_timestamp;" gives the
correct response through pgpool-II.<br>
<br>
Sean<br>
<br>
<br>
On 13-09-10 02:20 PM, Sean Hogan wrote:<br>
</div>
<blockquote cite="mid:522F4DD2.30002@compusult.net" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<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 moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a>
<a moz-do-not-send="true" 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>
<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>