Problems with timezone
| От | JotaComm |
|---|---|
| Тема | Problems with timezone |
| Дата | |
| Msg-id | CAA8OQ6_tT_d5x5q4Mun+dAzcshna_yw2A9rhNgsbQ-Pi5ddTXA@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Problems with timezone
|
| Список | 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)
now
-------------------------------
2015-07-27 16:26:40.001694-03
(1 row)
postgres@postgres =# SHOW timezone;
TimeZone
-------------
Brazil/East
(1 row)
TimeZone
-------------
Brazil/East
(1 row)
postgres@postgres =# SELECT blah;
ERROR: column "blah" does not exist
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;
[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
CentOS release 6.3 (Final)
Kernel \r on an \m
Could you help me?
Thanks a lot.
Best regards
--
JotaComm
http://jotacomm.wordpress.com
http://jotacomm.wordpress.com
В списке pgsql-general по дате отправления: