Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gS6pY-0007Km-2v for pgsql-bugs@arkaria.postgresql.org; Wed, 28 Nov 2018 20:53:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gS6pW-0000gV-QT for pgsql-bugs@arkaria.postgresql.org; Wed, 28 Nov 2018 20:53:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gS6pW-0000gN-Jl for pgsql-bugs@lists.postgresql.org; Wed, 28 Nov 2018 20:53:06 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gS6pT-0008Aj-L9 for pgsql-bugs@lists.postgresql.org; Wed, 28 Nov 2018 20:53:06 +0000 Content-Type: multipart/mixed; boundary="===============0824865921482240060==" MIME-Version: 1.0 Subject: BUG #15527: Issue converting from local date/time to 'timestamp with time zone' prior to dst transition To: pgsql-bugs@lists.postgresql.org From: =?utf-8?q?PG_Bug_reporting_form?= Cc: packfan91@gmail.com Reply-To: packfan91@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 28 Nov 2018 20:52:45 +0000 Message-ID: <15527-f1be0b4dc99ebbe7@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============0824865921482240060== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNTUyNwpMb2dnZWQgYnk6ICAgICAgICAgIE1pY2hhZWwgRGF2aWRzb24K RW1haWwgYWRkcmVzczogICAgICBwYWNrZmFuOTFAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogOS42LjEwCk9wZXJhdGluZyBzeXN0ZW06ICAgQ2VudE9TIDYtOS5lbDYuMTIuMwpEZXNjcmlw dGlvbjogICAgICAgIAoKV2UgaGF2ZSBhbiBhcHBsaWNhdGlvbiB0aGF0IGlzIHN0b3JpbmcgdGlt ZSBzZXJpZXMgZGF0YSBpbiBwb3N0Z3JlcyB1c2luZwondGltZXN0YW1wIHdpdGggdGltZSB6b25l JyBmaWVsZC4gIEJvdGggdGhlIG9wZXJhdGluZyBzeXN0ZW0gYW5kIHBvc3RncmVzCmFyZSBjb25m aWd1cmVkIHVzaW5nICdVUy9FYXN0ZXJuJyB0aW1lIHpvbmUuICBObyB0aW1lem9uZSBpcyBiZWlu ZyBwcm92aWRlZAppbiB0aGUgZGF0ZS90aW1lIHZhbHVlcyBiZWluZyBpbnNlcnRlZC4gIFdlIG5v dGljZWQgdGhhdCBvbiAxMS80LzIwMTggb25lCmhvdXIgd29ydGggb2YgcmVhZGluZ3MgKGZyb20g MWFtIHRvIDJhbSBVUy9FYXN0ZXJuKSBhcmUgbWlzc2luZy4gICBEdWUgdG8KdGhlIGRzdCBydWxl cyBmb3IgJ1VTL0Vhc3Rlcm4nIHRoZSBVVEMgb2Zmc2V0IHNob3VsZCB0cmFuc2l0aW9uIGZyb20g LTA0IHRvCi0wNSBvbiAxMS80LzIwMTggYXQgMmFtIFVTL0Vhc3Rlcm4uICBIb3dldmVyLCBwbGVh c2UgdGFrZSBhIGxvb2sgYXQgdGhlCm91dHB1dCBiZWxvdy4gIEl0IGxvb2tzIHRvIG1lIGFzIGlm IHBvc3RncmVzIGlzIGNoYW5naW5nIHRoZSBVVEMgb2Zmc2V0IGZyb20KLTA0IHRvIC0wNSBhdCAx YW0gaW5zdGVhZCBvZiBhdCAyYW0uICBJJ20gd29uZGVyaW5nIGlmIHRoaXMgaXMgYnkgZGVzaWdu Lg0KDQpyYXJpdGFuPSMgc2VsZWN0IG5vdygpOw0KICAgICAgICAgICAgIG5vdw0KLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogMjAxOC0xMS0wNCAwMDowNToxOC45MTM2My0wNA0KKDEg cm93KQ0KDQpyYXJpdGFuPSMgU0VMRUNUICogRlJPTSBwZ190aW1lem9uZV9uYW1lcyB3aGVyZSBu YW1lID0gJ1VTL0Vhc3Rlcm4nOw0KICAgICAgIG5hbWUgICAgICAgfCBhYmJyZXYgfCB1dGNfb2Zm c2V0IHwgaXNfZHN0DQotLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0tLS0tKy0t LS0tLS0tDQogVVMvRWFzdGVybiAgICAgICB8IEVEVCAgICB8IC0wNDowMDowMCAgfCB0DQooMSBy b3cpDQoNCnJhcml0YW49IyBzZWxlY3QgJzIwMTgtMTEtMDQgMDA6MDA6MDAnOjp0aW1lc3RhbXAg d2l0aCB0aW1lIHpvbmU7DQogICAgICB0aW1lc3RhbXB0eg0KLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tDQogMjAxOC0xMS0wNCAwMDowMDowMC0wNA0KKDEgcm93KQ0KDQpyYXJpdGFuPSMgc2VsZWN0 ICcyMDE4LTExLTA0IDAxOjAwOjAwJzo6dGltZXN0YW1wIHdpdGggdGltZSB6b25lOw0KICAgICAg dGltZXN0YW1wdHoNCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIDIwMTgtMTEtMDQgMDE6MDA6 MDAtMDUgICAgICAgICAgICAgICAgPD09PT09PSAgc2hvdWxkbid0IHRoaXMgYmUgLTA0CmJlY2F1 c2Ugc3RpbGwgaW4gZGF5bGlnaHQgc2F2aW5ncyB0aW1lPw0KKDEgcm93KQ0KDQpJIHN1c3BlY3Qg dGhhdCBwb3N0Z3JlcyBkb2Vzbid0IHRha2UgaW50byBhY2NvdW50IHRoZSBjdXJyZW50IHRpbWUg YW5kCndoZXRoZXIgb3Igbm90IGRheWxpZ2h0IHNhdmluZ3MgdGltZSBpcyBjdXJyZW50bHkgaW4g ZWZmZWN0IHdoZW4gY29udmVydGluZwp0byBVVEMuICBJZiB0aGF0J3MgdGhlIGNhc2UgdGhlcmUn cyBubyB3YXkgdG8ga25vdyBpZiB0aGUgZGF0ZS90aW1lIGJlaW5nCmluc2VydGVkIGlzIDFhbSBF RFQgKFVUQyAtMDQpIG9yIDFhbSBFU1QgKFVUQyAtMDUpICBQZXJoYXBzIHBvc3RncmVzIGp1c3QK Y2hvc2UgdG8gZ28gd2l0aCB0aGUgbGF0dGVyIHJlZ2FyZGxlc3Mgb2YgdGhlIGN1cnJlbnQgdGlt ZS4gIEkgbG9va2VkIGF0IHRoZQpkb2N1bWVudGF0aW9uIGJ1dCBkaWRuJ3Qgbm90aWNlIGFueXRo aW5nIHRoYXQgc3BlY2lmaWNhbGx5IGFkZHJlc3NlZCB0aGlzCmRldGFpbC4KCg== --===============0824865921482240060==--