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 1pWu03-0005B6-V2 for pgsql-bugs@arkaria.postgresql.org; Tue, 28 Feb 2023 07:02:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pWu01-0002Wv-BT for pgsql-bugs@arkaria.postgresql.org; Tue, 28 Feb 2023 07:02:09 +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 1pWqQU-0007Qn-8g for pgsql-bugs@lists.postgresql.org; Tue, 28 Feb 2023 03:13:14 +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 1pWqQM-0003jm-5Y for pgsql-bugs@lists.postgresql.org; Tue, 28 Feb 2023 03:13: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=kQkEaQu8B6gvNC6SJENYPdi2cfPxQ6km+tZVo2e3svA=; b=vvze0DLCx6+6yGIfBG1GnR37Gx hjWFoAK/a8tVYJznGj4Up46QTf4zlLgISebaUJPCRA8Hv7M+doSLK8yk4HbIhfmbz9edJxzSdWlTk 1xmvf4933h1d4EAp25WOhCwSubzmhiNrHQFM6M/2vahRV7u0TSVl/EeeJaGeEmW5ZZrql7zMz0aWD hcTP3ljI0a+0QLI8pAIEQw16tBRVSfy2HOL5NQioGu94jsIV89ZPyCAhCxxflKLEuAbAGUqa2JRpM FXATal4W3IBwmeY2FREZjvQtPy3D07D5RTsQWYWgcaQhw0WfWxMqTcRTSzlxMBC1ifgedQV6IwFjP bddIoe0w==; 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 1pWqQL-0005E0-Hf for pgsql-bugs@lists.postgresql.org; Tue, 28 Feb 2023 03:13:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pWqQH-003fp3-PN for pgsql-bugs@lists.postgresql.org; Tue, 28 Feb 2023 03:13:02 +0000 Content-Type: multipart/mixed; boundary="===============7617708076927237411==" MIME-Version: 1.0 Subject: BUG #17812: LOCK TABLE IN ACCESS EXCLUSIVE MODE with a view returns an empty tuple set To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: smartkeyerror@gmail.com Reply-To: smartkeyerror@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 28 Feb 2023 03:12:38 +0000 Message-ID: <17812-206eaec1d133a94a@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 --===============7617708076927237411== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzgxMgpMb2dnZWQgYnk6ICAgICAgICAgIFpoZW5nbG9uZyBMaQpFbWFp bCBhZGRyZXNzOiAgICAgIHNtYXJ0a2V5ZXJyb3JAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTUuMgpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMC4wNApEZXNjcmlwdGlvbjogICAg ICAgIAoKU3RlcCB0byByZXByb2R1Y2UgdGhlIGJlaGF2aW9yDQoNCldlIG5lZWQgMiBzZXNzaW9u cyB0byByZXByb2R1Y2UgdGhpcyBidWcuIA0KDQpGaXJzdGx5LCB3ZSBjcmVhdGUgYSBzaW1wbGUg dmlldyB0aGF0IGp1c3QgZmV0Y2hlcyBhbGwgdGhlIGRhdGEgZnJvbQp0YWJsZTEuDQoNCkFuZCB0 aGVuIHdlIHN0YXJ0IGEgdHJhbnNhY3Rpb24gYW5kIGxvY2sgdGFibGUxIHdpdGggQWNjZXNzRXhj bHVzaXZlIE1vZGUgaW4KUmVhZCBDb21taXR0ZWQgVHJhbnNhY3Rpb24gSXNvbGF0aW9uIExldmVs Lg0KDQpBZnRlciB0aGF0LCB3ZSB0cnkgdG8gdXNlIENUQVMgdG8gY3JlYXRlIGEgdGVtcCB0YWJs ZSB0YWJsZTIgdXNpbmcgdGhlIGRhdGEKZnJvbSB0YWJsZTEgaW4gc2Vzc2lvbjIsIGFuZCB0aGlz IHdpbGwgYmUgYmxvY2tlZCBieSBBY2Nlc3NFeGNsdXNpdmUgTG9jay4NCg0KRmluYWxseSwgd2Ug aW5zZXJ0IHNvbWUgZGF0YSBpbnRvIHRhYmxlMSBpbiBzZXNzaW9uMSBhbmQgY29tbWl0IGl0LCBz ZXNzaW9uMgp3aWxsIGNvbnRpbnVlLCBidXQgdGhlcmUgaXMgbm8gZGF0YSBpbiB0YWJsZTIuDQoN CmBgYHNxbA0KLS0tLS0tLS1bIFNlc3Npb25zIDEgXS0tLS0tLS0tDQoNCnNob3cgdHJhbnNhY3Rp b25faXNvbGF0aW9uOw0KIHRyYW5zYWN0aW9uX2lzb2xhdGlvbiANCi0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tDQogcmVhZCBjb21taXR0ZWQNCg0KRFJPUCBUQUJMRSBJRiBFWElTVFMgdGFibGUxIENB U0NBREU7DQoNCkNSRUFURSBUQUJMRSB0YWJsZTEgKA0KCXphaGwgICAgaW50ZWdlciwNCgl1cGRf ZGF0IHRpbWVzdGFtcCB3aXRob3V0IHRpbWUgem9uZQ0KKTsNCg0KQ1JFQVRFIE9SIFJFUExBQ0Ug VklFVyB2aWV3MSBhcyBzZWxlY3QgemFobCx1cGRfZGF0IGZyb20gdGFibGUxOw0KDQpCRUdJTjsN CkxPQ0sgVEFCTEUgdGFibGUxIElOIEFDQ0VTUyBFWENMVVNJVkUgTU9ERTsNClRSVU5DQVRFIFRB QkxFIHRhYmxlMTsNCg0KLS0tLS0tLS1bIFNlc3Npb25zIDIgXS0tLS0tLS0tDQoNCnNob3cgdHJh bnNhY3Rpb25faXNvbGF0aW9uOw0KIHRyYW5zYWN0aW9uX2lzb2xhdGlvbiANCi0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tDQogcmVhZCBjb21taXR0ZWQNCg0KRFJPUCBUQUJMRSBJRiBFWElTVFMgdGFi bGUyIENBU0NBREU7DQoNCkNSRUFURSBURU1QIFRBQkxFIHRhYmxlMiBBUyBzZWxlY3QgemFobCx1 cGRfZGF0IGZyb20gdmlldzE7DQotLSB0aGlzIHdpbGwgaGFuZyBub3cgd2FpdGluZyBmb3IgYSBs b2NrIGZvcm0gc2Vzc2lvbjENCg0KLS0tLS0tLS1bIFNlc3Npb25zIDEgXS0tLS0tLS0tDQpTRUxF Q1QgY2xvY2tfdGltZXN0YW1wKCk7DQpJTlNFUlQgSU5UTyB0YWJsZTEgU0VMRUNUIGkgemFobCxj bG9ja190aW1lc3RhbXAoKSB1cGRfZGF0IEZST00KZ2VuZXJhdGVfc2VyaWVzKDEsMTApIGEoaSk7 DQpDT01NSVQ7DQoNCi0tLS0tLS0tWyBTZXNzaW9ucyAyIF0tLS0tLS0tLQ0KU0VMRUNUICogRlJP TSB0YWJsZTIgbGltaXQgMTA7DQogemFobCB8IHVwZF9kYXQgDQotLS0tLS0rLS0tLS0tLS0tDQoo MCByb3dzKQ0KYGBgDQoNCiBCdXQgd2hlbiB3ZSB1c2VkIGEgdGFibGUsIHRoZXJlIHdpbGwgaGF2 ZSBkYXRhOg0KDQpgYGBzcWwNCi0tLS0tLS0tWyBTZXNzaW9ucyAxIF0tLS0tLS0tLQ0KDQpEUk9Q IFRBQkxFIElGIEVYSVNUUyB0YWJsZTEgQ0FTQ0FERTsNCg0KQ1JFQVRFIFRBQkxFIHRhYmxlMSAo DQoJemFobCAgICBpbnRlZ2VyLA0KCXVwZF9kYXQgdGltZXN0YW1wIHdpdGhvdXQgdGltZSB6b25l DQopOw0KDQpDUkVBVEUgT1IgUkVQTEFDRSBWSUVXIHZpZXcxIGFzIHNlbGVjdCB6YWhsLHVwZF9k YXQgZnJvbSB0YWJsZTE7DQoNCkJFR0lOOw0KTE9DSyBUQUJMRSB0YWJsZTEgSU4gQUNDRVNTIEVY Q0xVU0lWRSBNT0RFOw0KVFJVTkNBVEUgVEFCTEUgdGFibGUxOw0KDQotLS0tLS0tLVsgU2Vzc2lv bnMgMiBdLS0tLS0tLS0NCg0KRFJPUCBUQUJMRSBJRiBFWElTVFMgdGFibGUyIENBU0NBREU7DQoN CkNSRUFURSBURU1QIFRBQkxFIHRhYmxlMiBBUyBzZWxlY3QgemFobCx1cGRfZGF0IGZyb20gdGFi bGUxOw0KLS0gdGhpcyB3aWxsIGhhbmcgbm93IHdhaXRpbmcgZm9yIGEgbG9jayBmb3JtIHNlc3Np b24xDQoNCi0tLS0tLS0tWyBTZXNzaW9ucyAxIF0tLS0tLS0tLQ0KU0VMRUNUIGNsb2NrX3RpbWVz dGFtcCgpOw0KSU5TRVJUIElOVE8gdGFibGUxIFNFTEVDVCBpIHphaGwsY2xvY2tfdGltZXN0YW1w KCkgdXBkX2RhdCBGUk9NCmdlbmVyYXRlX3NlcmllcygxLDEwKSBhKGkpOw0KQ09NTUlUOw0KDQot LS0tLS0tLVsgU2Vzc2lvbnMgMiBdLS0tLS0tLS0NClNFTEVDVCAqIEZST00gdGFibGUyIGxpbWl0 IDEwOw0KIHphaGwgfCAgICAgICAgICB1cGRfZGF0ICAgICAgICAgICANCi0tLS0tLSstLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogICAgMSB8IDIwMjMtMDItMjggMDM6MTA6MTUuNzQzMDY4 DQogICAgMiB8IDIwMjMtMDItMjggMDM6MTA6MTUuNzQzMTk2DQogICAgMyB8IDIwMjMtMDItMjgg MDM6MTA6MTUuNzQzMjAzDQogICAgNCB8IDIwMjMtMDItMjggMDM6MTA6MTUuNzQzMjA2DQogICAg NSB8IDIwMjMtMDItMjggMDM6MTA6MTUuNzQzMjA4DQogICAgNiB8IDIwMjMtMDItMjggMDM6MTA6 MTUuNzQzMjENCiAgICA3IHwgMjAyMy0wMi0yOCAwMzoxMDoxNS43NDMyMTINCiAgICA4IHwgMjAy My0wMi0yOCAwMzoxMDoxNS43NDMyMTQNCiAgICA5IHwgMjAyMy0wMi0yOCAwMzoxMDoxNS43NDMy MTYNCiAgIDEwIHwgMjAyMy0wMi0yOCAwMzoxMDoxNS43NDMyMTgNCigxMCByb3dzKQ0KYGBgCgo= --===============7617708076927237411==--