Silent Data Manipulation - Time(stamp) w/o Time Zone Literals w/ TZ

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Silent Data Manipulation - Time(stamp) w/o Time Zone Literals w/ TZ
Date: 2015-05-12 17:57:39
Message-ID: CAKFQuwa_yYniA0mbWq=5TNP9OkAF1HdwV7Fy9tb0-aOmYAOOKQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

​"​In a literal that has been determined to be timestamp without time zone,
PostgreSQL will silently ignore any time zone indication. That is, the
resulting value is derived from the date/time fields in the input value,
and is not adjusted for time zone.​​"​

http://www.postgresql.org/docs/9.3/static/datatype-datetime.html

8.5.1.3 Time Stamps

Not exactly a widely impactful decision but is there harm in emitting a

"NOTICE: timezone specification ignored"

Just got a complaint on -admin about this:

http://www.postgresql.org/message-id/CACT-NGKQRtBGKOGUMT_goxyKu=yym8ET1Q5my-yjfuWW++uXbA@mail.gmail.com

David J.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephen Frost 2015-05-12 17:57:47 Re: Multi-xacts and our process problem
Previous Message Alvaro Herrera 2015-05-12 17:52:21 Re: BRIN range operator class