Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n8Je8-00013s-Hc for pgsql-bugs@arkaria.postgresql.org; Fri, 14 Jan 2022 10:17:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n8Je7-0001Dl-Ct for pgsql-bugs@arkaria.postgresql.org; Fri, 14 Jan 2022 10:17:23 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n8Drt-00083f-Tx for pgsql-bugs@lists.postgresql.org; Fri, 14 Jan 2022 04:07:13 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n8Drn-0002hY-B6 for pgsql-bugs@lists.postgresql.org; Fri, 14 Jan 2022 04:07:12 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=mzSfOlLHSdbBx3y5q4FABxwGUypPG0ikO2oGKAVe9hA=; b=ayRdYPhjec+wQ147Ipr5o381ey TJALJIAYY2Uql4m46Qfx20BPf5c8DMhkcrqZp3sY+e6obcBA1LUO4hrICgTtUyAYwk1+J7/pH0+/q ISNvucg14yC+5br/DhZg3NCYVvmrIp2JM2AoxiHJOjbREoq/C6Utfy7KnIjhUkcqr0Y5LQsXw2m62 Zc1hoQ2TCgac+jAaOoBtyVwXdnR530ulJ9PDtosnix0PsekULiGSnLG9Vc8K2QKOrh7aGqJkV9prW ekPiUVhUQa/NobisWxRV8OCoxVPj4nP98A98yzCpcxTZlHDXIZj3Gp7brte3Fxl/LsmqrYA9sJaDR 4HSqUQbg==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n8Drl-0006p1-9i for pgsql-bugs@lists.postgresql.org; Fri, 14 Jan 2022 04:07:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n8Dri-0002ew-No for pgsql-bugs@lists.postgresql.org; Fri, 14 Jan 2022 04:07:02 +0000 Content-Type: multipart/mixed; boundary="===============6721607197933265729==" MIME-Version: 1.0 Subject: BUG #17366: Error result returned in timestamp2timestamptz, expected to be off by one hour To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: dafoer_x@163.com Reply-To: dafoer_x@163.com, pgsql-bugs@lists.postgresql.org Date: Fri, 14 Jan 2022 04:06:42 +0000 Message-ID: <17366-8744a901d10fd9d1@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6721607197933265729== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzM2NgpMb2dnZWQgYnk6ICAgICAgICAgIEVycm9yIHJlc3VsdCByZXR1 cm5lZCBpbiB0aW1lc3RhbXAydGltZXN0YW1wdHosIGV4cGVjdGVkIHRvIGJlIG9mZiBieSBvbmUK aG91cgpFbWFpbCBhZGRyZXNzOiAgICAgIGRhZm9lcl94QDE2My5jb20KUG9zdGdyZVNRTCB2ZXJz aW9uOiAxNC4xCk9wZXJhdGluZyBzeXN0ZW06ICAgUkVMXzE0X1NUQUJMRQpEZXNjcmlwdGlvbjog ICAgICAgIAoKRm9yIFJFTF8xNF9TVEFCTEUNCmdpdCBsb2cgYWQ1YjZmMjQ4YWIyODhjMzI1MmQ4 MTIyZDEyYTFlYjQxMGQ0YTBiNg0KDQplLmcuDQpwb3N0Z3Jlcz0jIHNldCB0aW1lem9uZSB0byAi UFNUOFBEVCI7DQpTRVQNCnBvc3RncmVzPSMgc2VsZWN0ICogZnJvbSBwZ190aW1lem9uZV9uYW1l cyB3aGVyZSBuYW1lID0gJ1BTVDhQRFQnOw0KICBuYW1lICAgfCBhYmJyZXYgfCB1dGNfb2Zmc2V0 IHwgaXNfZHN0IA0KLS0tLS0tLS0tKy0tLS0tLS0tKy0tLS0tLS0tLS0tLSstLS0tLS0tLQ0KIFBT VDhQRFQgfCBQU1QgICAgfCAtMDg6MDA6MDAgIHwgZg0KKDEgcm93KQ0KDQpwb3N0Z3Jlcz0jIHNl bGVjdCAodGltZXN0YW1wICcyMDIxLTAzLTE0IDAyOjAwOjAwJyk6OnRpbWVzdGFtcHR6Ow0KICAg ICAgdGltZXN0YW1wdHogICAgICAgDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiAyMDIxLTAz LTE0IDAzOjAwOjAwLTA3DQooMSByb3cpDQoNCnBvc3RncmVzPSMgc2VsZWN0ICh0aW1lc3RhbXAg JzIwMjEtMDMtMTQgMDM6MDA6MDAnKTo6dGltZXN0YW1wdHo7DQogICAgICB0aW1lc3RhbXB0eiAg ICAgICANCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIDIwMjEtMDMtMTQgMDM6MDA6MDAtMDcN CigxIHJvdykNCg0KDQpleHBlY3RlZDoNCnBvc3RncmVzPSMgc2VsZWN0ICh0aW1lc3RhbXAgJzIw MjEtMDMtMTQgMDI6MDA6MDAnKTo6dGltZXN0YW1wdHo7DQoyMDIxLTAzLTE0IDAyOjAwOjAwLTA3 Cgo= --===============6721607197933265729==--