| 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:
David J.
| 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 |