From: | JotaComm <jota(dot)comm(at)gmail(dot)com> |
---|---|
To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Problems with timezone |
Date: | 2015-07-27 19:36:36 |
Message-ID: | CAA8OQ6_tT_d5x5q4Mun+dAzcshna_yw2A9rhNgsbQ-Pi5ddTXA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I have the following inconsistency in my environment:
postgres(at)postgres =# SELECT current_timestamp;
now
-------------------------------
*2015-07-27 16:26:40.001694-03*
(1 row)
postgres(at)postgres =# SHOW timezone;
TimeZone
-------------
Brazil/East
(1 row)
postgres(at)postgres =# SELECT blah;
ERROR: column "blah" does not exist
In my log file:
[*2015-07-27 19:27:10.944 GMT*] 3397 <postgres postgres [local] 42703>
ERROR: column "blah" does not exist at character 8
[*2015-07-27 19:27:10.944 GMT*] 3397 <postgres postgres [local] 42703>
STATEMENT: SELECT blah;
My PostgreSQL version is: 9.2.4
cat /etc/issue
CentOS release 6.3 (Final)
Kernel \r on an \m
Could you help me?
Thanks a lot.
Best regards
--
JotaComm
http://jotacomm.wordpress.com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2015-07-27 19:41:41 | Re: Problems with timezone |
Previous Message | Adrian Klaver | 2015-07-27 18:01:56 | Re: pg_dump error |