Problems with timezone - Mailing list pgsql-general

From JotaComm
Subject Problems with timezone
Date
Msg-id CAA8OQ6_tT_d5x5q4Mun+dAzcshna_yw2A9rhNgsbQ-Pi5ddTXA@mail.gmail.com
Whole thread Raw
Responses Re: Problems with timezone  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general

​Hello,

I have the following inconsistency in my environment:

postgres@postgres =# SELECT current_timestamp;
              now
-------------------------------
 2015-07-27 16:26:40.001694-03
(1 row)

postgres@postgres =# SHOW timezone;
  TimeZone
-------------
 Brazil/East
(1 row)

postgres@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


--

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pg_dump error
Next
From: Adrian Klaver
Date:
Subject: Re: Problems with timezone