Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rjoEx-0080wi-Ik for pgsql-bugs@arkaria.postgresql.org; Mon, 11 Mar 2024 22:35:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rjoEt-001vro-N5 for pgsql-bugs@arkaria.postgresql.org; Mon, 11 Mar 2024 22:35:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rjlzK-000VRb-CY for pgsql-bugs@lists.postgresql.org; Mon, 11 Mar 2024 20:11:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rjlzF-003zoh-P5 for pgsql-bugs@lists.postgresql.org; Mon, 11 Mar 2024 20:11:10 +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=+cAg3xrCwmVBviCG7TWlaxR8tDcssl03UFLjLywC0sM=; b=C6McpYEKC2jP6hJoZQb5Pd+0Lo xnG0FrmaIvfj7h3rp5euktAjm/OhbUrBcCYgGhc29tpyVuMe0csUb8wiIOyk45hfTUTZnGUyoKFNE TERoTN3cB17YY1bWHGJ0cjOyrWDZvPna5lH5JexdIsGje44Q+E61fGCcXyl7oZksx/0SBvwNjOchZ tSjHCH9xUxY02uBGDX+O262jYvkBDboffj/5SY5fNFA6hghprOmSRk+3zz5H81xcBw69NfdIftvnY TfmOcZZTfl2sK3OyXrsRHvTXLg5ooJfKz57vzptfPeMmRkvCZBQXivGFNjF6iQHjb/xlWAVaC1dbe hCQm95+A==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rjlzD-00AIxi-M4 for pgsql-bugs@lists.postgresql.org; Mon, 11 Mar 2024 20:11:04 +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 1rjlzB-00Ebrr-Op for pgsql-bugs@lists.postgresql.org; Mon, 11 Mar 2024 20:11:02 +0000 Content-Type: multipart/mixed; boundary="===============9091809321877171208==" MIME-Version: 1.0 Subject: BUG #18387: Erroneous permission checks and/or misleading error messages with refresh materialized view To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: maxim.boguk@gmail.com Reply-To: maxim.boguk@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 11 Mar 2024 20:10:08 +0000 Message-ID: <18387-12041858d9efb6f6@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 --===============9091809321877171208== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODM4NwpMb2dnZWQgYnk6ICAgICAgICAgIE1heGltIEJvZ3VrCkVtYWls IGFkZHJlc3M6ICAgICAgbWF4aW0uYm9ndWtAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTYuMgpPcGVyYXRpbmcgc3lzdGVtOiAgIExpbnV4CkRlc2NyaXB0aW9uOiAgICAgICAgCgpIaSwN Cg0KVGhlcmUgYXJlIHdlaXJkIGJlaGF2aW9yIHdpdGggcGVybWlzc2lvbiBjaGVja3MgZm9yIHJl ZnJlc2ggbWF0ZXJpYWxpemVkCnZpZXcgZm9yIHN1cGVydXNlci4NClJlcHJvZHVjZXIgc2NyaXB0 IChydW4gZnJvbSBwb3N0Z3Jlcyk6DQoNCmNyZWF0ZSByb2xlIHRlc3Rfcm9sZTsNCmNyZWF0ZSBk YXRhYmFzZSB0ZXN0IHdpdGggb3duZXIgcG9zdGdyZXM7DQpcYyB0ZXN0DQpjcmVhdGUgdGFibGUg dGVzdCBhcyBzZWxlY3QgMSB2YWw7DQpjcmVhdGUgbWF0ZXJpYWxpemVkIHZpZXcgdGVzdF9tdiBh cyBzZWxlY3QgKiBmcm9tIHRlc3Q7DQpSRUZSRVNIIE1BVEVSSUFMSVpFRCBWSUVXIHRlc3RfbXY7 DQpjcmVhdGUgdW5pcXVlIGluZGV4IHRlc3RfbXZfcGsgb24gdGVzdF9tdih2YWwpOw0KUkVGUkVT SCBNQVRFUklBTElaRUQgVklFVyBDT05DVVJSRU5UTFkgdGVzdF9tdjsNCmFsdGVyIG1hdGVyaWFs aXplZCB2aWV3IHRlc3RfbXYgb3duZXIgdG8gdGVzdF9yb2xlOw0KUkVGUkVTSCBNQVRFUklBTEla RUQgVklFVyBDT05DVVJSRU5UTFkgdGVzdF9tdjsNCnNlbGVjdCAqIGZyb20gdGVzdDsNCnJldm9r ZSB0ZW1wb3Jhcnkgb24gZGF0YWJhc2UgdGVzdCBmcm9tIHB1YmxpYzsNClxjIHRlc3QNClJFRlJF U0ggTUFURVJJQUxJWkVEIFZJRVcgQ09OQ1VSUkVOVExZIHRlc3RfbXY7DQpSRUZSRVNIIE1BVEVS SUFMSVpFRCBWSUVXIHRlc3RfbXY7DQoNClJlcHJvZHVjZXIgbG9nIChzdGFydGluZyBmcm9tIGlu dGVyZXN0aW5nIHBhcnQpOg0KdGVzdD0jIFJFRlJFU0ggTUFURVJJQUxJWkVEIFZJRVcgQ09OQ1VS UkVOVExZIHRlc3RfbXY7DQpSRUZSRVNIIE1BVEVSSUFMSVpFRCBWSUVXDQp0ZXN0PSMgYWx0ZXIg bWF0ZXJpYWxpemVkIHZpZXcgdGVzdF9tdiBvd25lciB0byB0ZXN0X3JvbGU7DQpBTFRFUiBNQVRF UklBTElaRUQgVklFVw0KdGVzdD0jIFJFRlJFU0ggTUFURVJJQUxJWkVEIFZJRVcgQ09OQ1VSUkVO VExZIHRlc3RfbXY7DQpFUlJPUjogIHBlcm1pc3Npb24gZGVuaWVkIGZvciB0YWJsZSB0ZXN0DQot LXdoYXQ/Pz8gTjENCg0KLS1jaGVjayB0aGF0IGltIG5vdCBoYWxsdWNpbmF0aW5nDQp0ZXN0PSMg c2VsZWN0ICogZnJvbSB0ZXN0Ow0KIHZhbCANCi0tLS0tDQogICAxDQooMSByb3cpDQoNCnRlc3Q9 IyByZXZva2UgdGVtcG9yYXJ5IG9uIGRhdGFiYXNlIHRlc3QgZnJvbSBwdWJsaWM7DQpSRVZPS0UN CnRlc3Q9IyBcYyB0ZXN0DQpZb3UgYXJlIG5vdyBjb25uZWN0ZWQgdG8gZGF0YWJhc2UgInRlc3Qi IGFzIHVzZXIgInBvc3RncmVzIi4NCnRlc3Q9IyBSRUZSRVNIIE1BVEVSSUFMSVpFRCBWSUVXIENP TkNVUlJFTlRMWSB0ZXN0X212Ow0KRVJST1I6ICBwZXJtaXNzaW9uIGRlbmllZCB0byBjcmVhdGUg dGVtcG9yYXJ5IHRhYmxlcyBpbiBkYXRhYmFzZSAidGVzdCINCi0td2hhdD8/PyBOMg0KDQp0ZXN0 PSMgUkVGUkVTSCBNQVRFUklBTElaRUQgVklFVyB0ZXN0X212Ow0KRVJST1I6ICBwZXJtaXNzaW9u IGRlbmllZCBmb3IgdGFibGUgdGVzdA0KLS13aXRob3V0IENPTkNVUlJFTlRMWSB3cm9uZyBiZWhh dmlvciB0b28KCg== --===============9091809321877171208==--