Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cTrgW-0003rw-9O for pgsql-bugs@arkaria.postgresql.org; Wed, 18 Jan 2017 14:58:00 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cTrgV-0003NK-MB for pgsql-bugs@arkaria.postgresql.org; Wed, 18 Jan 2017 14:57:59 +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_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cTrXw-0002oz-13 for pgsql-bugs@postgresql.org; Wed, 18 Jan 2017 14:49:08 +0000 Received: from wrigleys.postgresql.org ([204.145.124.246]) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cTrXq-0000wf-NK for pgsql-bugs@postgresql.org; Wed, 18 Jan 2017 14:49:07 +0000 MIME-Version: 1.0 Subject: BUG #14504: Wrong index using via view for converted timestamp by time zone To: pgsql-bugs@postgresql.org From: dsuchka@gmail.com Date: Wed, 18 Jan 2017 14:48:28 +0000 Message-ID: <20170118144828.1432.52823@wrigleys.postgresql.org> X-Pg-Spam-Score: -0.3 (/) Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-bugs Precedence: bulk Sender: pgsql-bugs-owner@postgresql.org VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDUwNApMb2dnZWQgYnk6ICAg ICAgICAgIEV2Z2VuaXkgS296bG92CkVtYWlsIGFkZHJlc3M6ICAgICAgZHN1 Y2hrYUBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiA5LjUuMgpPcGVy YXRpbmcgc3lzdGVtOiAgIEdOVVxMaW51eCAoR2VudG9vIDQuOS4zIHAxLjUs IHBpZS0wLjYuNCkKRGVzY3JpcHRpb246ICAgICAgICAKCkkndmUgYmVlbiBh IGxpdHRsZSBiaXQgc3VycHJpc2VkIGJ5IHN1Y2ggYmVoYXZpb3VyIHdoZW4g c29tZXRpbWVzIHF1ZXJ5CnJldHVybnMgZXhwZWN0ZWQgcm93cyBhbmQgc29t ZXRpbWVzIGRvZXMgbm90IGJ5IHRoZSBzYW1lIGNvbmRpdGlvbiBkZXBlbmRp bmcKb24gaW5kZXggdXNhZ2UgKGFzIHNob3duIGV4cGxhaW4gYW5hbHl6ZSks IGFuZCBubyByb3dzIHJlbW92ZWQgZnJvbSB0aGUKdGFibGUuDQoNCkhvdyB0 byByZXByb2R1Y2UgaXQ6DQoNCi0tIGNyZWF0ZSB0YWJsZSB3aXRoIHRpbWVf c3RhbXAgY29sdW1uICYgY3JlYXRlIHZpZXcgd2l0aCB0aW1lX3N0YW1wICsK dGltZV9zdGFtcCBhdCBVVEMNCmR6aGVpa2E9IyBDUkVBVEUgVEFCTEUgdGVz dF90el9idWcgKGlkIGludGVnZXIgUFJJTUFSWSBLRVksIHRpbWVfc3RhbXAK dGltZXN0YW1wdHogTk9UIE5VTEwgREVGQVVMVCBjbG9ja190aW1lc3RhbXAo KSk7DQpDUkVBVEUgVEFCTEUNCmR6aGVpa2E9IyBDUkVBVEUgVklFVyB0ZXN0 X3R6X2J1Z192aWV3IEFTIFNFTEVDVCB4LmlkLCB4LnRpbWVfc3RhbXAsCngu dGltZV9zdGFtcCBBVCBUSU1FIFpPTkUgJ1VUQycgQVMgdGltZV9zdGFtcF9h dF91dGMgRlJPTSB0ZXN0X3R6X2J1ZyBBUwp4Ow0KQ1JFQVRFIFZJRVcNCg0K LS0gZmlsbCBkYXRhDQpkemhlaWthPSMgV0lUSCBSRUNVUlNJVkUgc3JjKGlk KSBBUyAoU0VMRUNUIDEgVU5JT04gU0VMRUNUIHMuaWQrMSBGUk9NIHNyYwpB UyBzIFdIRVJFIHMuaWQgPCAxMDAwMCkgSU5TRVJUIElOVE8gdGVzdF90el9i dWcoaWQpIFNFTEVDVCB4LmlkIEZST00gc3JjIEFTCng7SU5TRVJUIDAgMTAw MDANCg0KDQotLSBub3cgd2UgY2FuIHNlbGVjdCBzb21lIHJvd3MgZnJvbSB2 aWV3IGluIDIgd2F5cyBieSB0aW1lIHZhbHVlOiB1c2luZwp0aW1lX3N0YW1w ICYgdGltZV9zdGFtcF9hdF91dGM6DQpkemhlaWthPSMgU0VMRUNUICogRlJP TSB0ZXN0X3R6X2J1Z192aWV3IFdIRVJFIGlkID0gNTU1NTsNCiAgaWQgIHwg ICAgICAgICAgdGltZV9zdGFtcCAgICAgICAgICAgfCAgICAgdGltZV9zdGFt cF9hdF91dGMgICAgICANCi0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiA1NTU1 IHwgMjAxNy0wMS0xOCAxNzoyNTo0MS40NTk5MjIrMDMgfCAyMDE3LTAxLTE4 IDE0OjI1OjQxLjQ1OTkyMg0KKDEg0YHRgtGA0L7QutCwKQ0KDQpkemhlaWth PSMgU0VMRUNUICogRlJPTSB0ZXN0X3R6X2J1Z192aWV3IFdIRVJFIHRpbWVf c3RhbXAgPSAnMjAxNy0wMS0xOAoxNzoyNTo0MS40NTk5MjIrMDMnOw0KICBp ZCAgfCAgICAgICAgICB0aW1lX3N0YW1wICAgICAgICAgICB8ICAgICB0aW1l X3N0YW1wX2F0X3V0YyAgICAgIA0KLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0K IDU1NTUgfCAyMDE3LTAxLTE4IDE3OjI1OjQxLjQ1OTkyMiswMyB8IDIwMTct MDEtMTggMTQ6MjU6NDEuNDU5OTIyDQooMSDRgdGC0YDQvtC60LApDQoNCmR6 aGVpa2E9IyBTRUxFQ1QgKiBGUk9NIHRlc3RfdHpfYnVnX3ZpZXcgV0hFUkUg dGltZV9zdGFtcF9hdF91dGMgPQonMjAxNy0wMS0xOCAxNDoyNTo0MS40NTk5 MjInOw0KICBpZCAgfCAgICAgICAgICB0aW1lX3N0YW1wICAgICAgICAgICB8 ICAgICB0aW1lX3N0YW1wX2F0X3V0YyAgICAgIA0KLS0tLS0tKy0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLQ0KIDU1NTUgfCAyMDE3LTAxLTE4IDE3OjI1OjQxLjQ1OTkyMisw MyB8IDIwMTctMDEtMTggMTQ6MjU6NDEuNDU5OTIyDQooMSDRgdGC0YDQvtC6 0LApDQoNCi0tDQotLSBCdXQgaWYgd2UgaGF2ZSBhbiBpbmRleCBvbiB0aGUg b3JpZ2luYWwgdGFibGUgYnkgdGhlIHRpbWVfc3RhbXAgY29sdW1uLApjb25k aXRpb24gd2l0aCBjb252ZXJ0ZWQgdGltZXN0YW1wIHdpbGwgd29yayBpbiB3 cm9uZyB3YXk6DQotLQ0KZHpoZWlrYT0jIENSRUFURSBJTkRFWCB0ZXN0X3R6 X2J1Z190aW1lX3N0YW1wX2lkeCBPTiB0ZXN0X3R6X2J1ZyBVU0lORyBidHJl ZQoodGltZV9zdGFtcCk7DQpDUkVBVEUgSU5ERVgNCmR6aGVpa2E9IyBBTkFM WVpFIHRlc3RfdHpfYnVnOw0KQU5BTFlaRQ0KZHpoZWlrYT0jIFNFTEVDVCAq IEZST00gdGVzdF90el9idWdfdmlldyBXSEVSRSB0aW1lX3N0YW1wX2F0X3V0 YyA9CicyMDE3LTAxLTE4IDE0OjI1OjQxLjQ1OTkyMic7DQogaWQgfCB0aW1l X3N0YW1wIHwgdGltZV9zdGFtcF9hdF91dGMgDQotLS0tKy0tLS0tLS0tLS0t LSstLS0tLS0tLS0tLS0tLS0tLS0tDQooMCDRgdGC0YDQvtC6KQ0KDQpkemhl aWthPSMgRVhQTEFJTiBBTkFMWVpFIFNFTEVDVCAqIEZST00gdGVzdF90el9i dWdfdmlldyBXSEVSRQp0aW1lX3N0YW1wX2F0X3V0YyA9ICcyMDE3LTAxLTE4 IDE0OjI1OjQxLjQ1OTkyMic7DQogICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgUVVFUlkg UExBTiAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgDQotLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogSW5kZXggU2NhbiB1 c2luZyB0ZXN0X3R6X2J1Z190aW1lX3N0YW1wX2lkeCBvbiB0ZXN0X3R6X2J1 ZyB4IAooY29zdD0wLjI5Li44LjMwIHJvd3M9MSB3aWR0aD0xMikgKGFjdHVh bCB0aW1lPTAuMDE2Li4wLjAxNiByb3dzPTAKbG9vcHM9MSkNCiAgIEluZGV4 IENvbmQ6ICgodGltZV9zdGFtcCk6OnRpbWVzdGFtcCB3aXRob3V0IHRpbWUg em9uZSA9ICcyMDE3LTAxLTE4CjE0OjI1OjQxLjQ1OTkyMic6OnRpbWVzdGFt cCB3aXRob3V0IHRpbWUgem9uZSkNCiBQbGFubmluZyB0aW1lOiAwLjE3NCBt cw0KIEV4ZWN1dGlvbiB0aW1lOiAwLjA0MyBtcw0KKDQg0YHRgtGA0L7QutC4 KQ0KDQoNCj09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PQ0KDQpJZiBh bm90aGVyIGluZGV4IGlzIHVzZWQgKG9yIG5vIGluZGljZXMgYXJlIHVzZWQp LCB0aGVuIHNlbGVjdCB3b3Jrcwpjb3JyZWN0bHk6DQoNCmR6aGVpa2E9IyBT RUxFQ1QgKiBGUk9NIHRlc3RfdHpfYnVnX3ZpZXcgV0hFUkUgKHRpbWVfc3Rh bXBfYXRfdXRjICsKJzFzJzo6aW50ZXJ2YWwpID0gKCcyMDE3LTAxLTE4IDE0 OjI1OjQxLjQ1OTkyMic6OnRpbWVzdGFtcCArCicxcyc6OmludGVydmFsKTsN CiAgaWQgIHwgICAgICAgICAgdGltZV9zdGFtcCAgICAgICAgICAgfCAgICAg dGltZV9zdGFtcF9hdF91dGMgICAgICANCi0tLS0tLSstLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0NCiA1NTU1IHwgMjAxNy0wMS0xOCAxNzoyNTo0MS40NTk5MjIrMDMgfCAy MDE3LTAxLTE4IDE0OjI1OjQxLjQ1OTkyMg0KKDEg0YHRgtGA0L7QutCwKQ0K DQpkemhlaWthPSMgRVhQTEFJTiBBTkFMWVpFIFNFTEVDVCAqIEZST00gdGVz dF90el9idWdfdmlldyBXSEVSRQoodGltZV9zdGFtcF9hdF91dGMgKyAnMXMn OjppbnRlcnZhbCkgPSAoJzIwMTctMDEtMTgKMTQ6MjU6NDEuNDU5OTIyJzo6 dGltZXN0YW1wICsgJzFzJzo6aW50ZXJ2YWwpOw0KICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICBRVUVSWSBQTEFOIAogICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCi0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQog U2VxIFNjYW4gb24gdGVzdF90el9idWcgeCAgKGNvc3Q9MC4wMC4uMjA1LjAw IHJvd3M9NTAgd2lkdGg9MTIpIChhY3R1YWwKdGltZT0yLjE2My4uMy41OTMg cm93cz0xIGxvb3BzPTEpDQogICBGaWx0ZXI6ICgoKHRpbWVfc3RhbXApOjp0 aW1lc3RhbXAgd2l0aG91dCB0aW1lIHpvbmUgKwonMDA6MDA6MDEnOjppbnRl cnZhbCkgPSAnMjAxNy0wMS0xOCAxNDoyNTo0Mi40NTk5MjInOjp0aW1lc3Rh bXAgd2l0aG91dCB0aW1lCnpvbmUpDQogICBSb3dzIFJlbW92ZWQgYnkgRmls dGVyOiA5OTk5DQogUGxhbm5pbmcgdGltZTogMC4yNDUgbXMNCiBFeGVjdXRp b24gdGltZTogMy42MjkgbXMNCig1INGB0YLRgNC+0LopDQoNCg0KPT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09DQpQb3N0Z3JlU1FMIDkuNS4yIG9u IHg4Nl82NC1wYy1saW51eC1nbnUsIGNvbXBpbGVkIGJ5IHg4Nl82NC1wYy1s aW51eC1nbnUtZ2NjCihHZW50b28gNC45LjMgcDEuNSwgcGllLTAuNi40KSA0 LjkuMywgNjQtYml0DQpQb3N0Z3JlU1FMIDkuNS4xIG9uIHg4Nl82NC1wYy1s aW51eC1nbnUsIGNvbXBpbGVkIGJ5IGdjYyAoRGViaWFuIDQuOS4yLTEwKQo0 LjkuMiwgNjQtYml0CgoKLS0gClNlbnQgdmlhIHBnc3FsLWJ1Z3MgbWFpbGlu ZyBsaXN0IChwZ3NxbC1idWdzQHBvc3RncmVzcWwub3JnKQpUbyBtYWtlIGNo YW5nZXMgdG8geW91ciBzdWJzY3JpcHRpb246Cmh0dHA6Ly93d3cucG9zdGdy ZXNxbC5vcmcvbWFpbHByZWYvcGdzcWwtYnVncwo=