Problems with timezone

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

Responses

Browse pgsql-general by date

  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