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 1tiAPc-00CHCz-LK for pgsql-bugs@arkaria.postgresql.org; Wed, 12 Feb 2025 10:56:12 +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 1tiAPa-008YfV-Li for pgsql-bugs@arkaria.postgresql.org; Wed, 12 Feb 2025 10:56:11 +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 1tiAPa-008YfK-Ak for pgsql-bugs@lists.postgresql.org; Wed, 12 Feb 2025 10:56:11 +0000 Received: from mx0a-00134001.pphosted.com ([205.220.160.129]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tiAPX-000QlU-1B for pgsql-bugs@lists.postgresql.org; Wed, 12 Feb 2025 10:56:10 +0000 Received: from pps.filterd (m0267959.ppops.net [127.0.0.1]) by mx0a-00134001.pphosted.com (8.18.1.2/8.18.1.2) with ESMTP id 51C8IBbM029193 for ; Wed, 12 Feb 2025 10:56:03 GMT DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=optiver.com; h= content-type:date:from:message-id:mime-version:subject:to; s= mail; bh=xXuCSbgl8Dl9tfD28nRmHLqgU5WspkilnByCuMlYS5o=; b=OqpZONA +q0fgZiaV7QytEaz4L+QNJQZl2PYx4qioTjApjl3nkOIkuCrSlLKwmV9gMZvqjss GD40EsFlVtyARGXzNridgjVzf5rZpomEcCWGeeVZT7YbZHTk4KqYG6txaiiJ7ugh U9vuNljDWj7U6LzIKr1Dm8IgFFG5RevFzoirqnxWGLpkTH10j5vRP+hNRwZAFJd9 e1WuwH5/21t9GD/sptGHomRLeVQrSmYUMK/kF5QCpCoDVwTUVi1Y6R8TFdYcbYQK 6lnzsopCqh/wHKysbyLoO2v56kWe61TPxlUmqXU8LWgCQveCr6aRZLPmJFMVbAXU 9OOkL71z8+ilk8Q== Received: from opammb1270.comp.optiver.com ([195.246.114.78]) by mx0a-00134001.pphosted.com (PPS) with ESMTPS id 44p0kmy2n5-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT) for ; Wed, 12 Feb 2025 10:56:03 +0000 (GMT) Received: from opammb1267.comp.optiver.com (100.68.11.12) by opammb1270.comp.optiver.com (100.68.11.18) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1118.26; Wed, 12 Feb 2025 11:56:01 +0100 Received: from opammb1267.comp.optiver.com ([fe80::5b6f:1976:98cd:68a7]) by opammb1267.comp.optiver.com ([fe80::5b6f:1976:98cd:68a7%13]) with mapi id 15.02.1118.026; Wed, 12 Feb 2025 11:56:01 +0100 From: Floris Van Nee To: "pgsql-bugs@lists.postgresql.org" Subject: Error for GRANTED BY in PG16&PG17 that does not happen in PG15 Thread-Topic: Error for GRANTED BY in PG16&PG17 that does not happen in PG15 Thread-Index: Adt9PDd4hTOkwuksQ7OVkc652f6+pA== Date: Wed, 12 Feb 2025 10:56:01 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [100.68.31.122] Content-Type: multipart/alternative; boundary="_000_bc5f945cbd27483f83a59880550722ceOptivercom_" MIME-Version: 1.0 X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.293,Aquarius:18.0.1057,Hydra:6.0.680,FMLib:17.12.68.34 definitions=2025-02-12_03,2025-02-11_01,2024-11-22_01 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_bc5f945cbd27483f83a59880550722ceOptivercom_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 SGksIEkgb2JzZXJ2ZWQgc29tZSBkaWZmZXJlbmNlIGluIGJlaGF2aW9yIGZvciBncmFudGluZyBy b2xlcy4NCg0KUnVubmluZyBhcyBhIHN1cGVydXNlciAocG9zdGdyZXMpLg0KDQpTUUw6DQpjcmVh dGUgcm9sZSB0ZXN0X2dyb3VwOw0KY3JlYXRlIHJvbGUgdGVzdF91c2VyOw0KY3JlYXRlIHJvbGUg dGVzdF9zdSB3aXRoIHN1cGVydXNlcjsNCmdyYW50IHRlc3RfZ3JvdXAgdG8gdGVzdF91c2VyIGdy YW50ZWQgYnkgdGVzdF9zdTsNCg0KT3V0cHV0IG9uIFBHMTYgJiBQRzE3Og0KQ1JFQVRFIFJPTEUN CkNSRUFURSBST0xFDQpDUkVBVEUgUk9MRQ0KRVJST1I6ICBwZXJtaXNzaW9uIGRlbmllZCB0byBn cmFudCBwcml2aWxlZ2VzIGFzIHJvbGUgInRlc3Rfc3UiDQpERVRBSUw6ICBUaGUgZ3JhbnRvciBt dXN0IGhhdmUgdGhlIEFETUlOIG9wdGlvbiBvbiByb2xlICJ0ZXN0X2dyb3VwIi4NCg0KVGhlIHNh bWUgc3VjY2VlZHMgb24gUEcxNS4NCg0KVGhpcyBsaWtlbHkgaGFzIHRvIGRvIHdpdGggd29yayB0 aGF0IHdhcyBkb25lIGJ5IFJvYmVydCBIYWFzIG9uIGludHJvZHVjaW5nIHRoaXMgQURNSU4gb3B0 aW9uIGluIFBHMTYuDQpTdXJlbHkgZG9pbmcg4oCcZ3JhbnRlZCBieSBzb21lX3N1cGVydXNlcuKA nSBzaG91bGQgYmUgYWxsb3dlZCByZWdhcmRsZXNzIG9mIHRoZSBBRE1JTiBvcHRpb24gdGhvdWdo LCByaWdodD8NCg0KLUZsb3Jpcw0KDQo= --_000_bc5f945cbd27483f83a59880550722ceOptivercom_ Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: base64 PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6bT0iaHR0cDovL3NjaGVtYXMubWlj cm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcv VFIvUkVDLWh0bWw0MCI+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIg Y29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxtZXRhIG5hbWU9IkdlbmVyYXRv ciIgY29udGVudD0iTWljcm9zb2Z0IFdvcmQgMTUgKGZpbHRlcmVkIG1lZGl1bSkiPg0KPHN0eWxl PjwhLS0NCi8qIEZvbnQgRGVmaW5pdGlvbnMgKi8NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6 IkNhbWJyaWEgTWF0aCI7DQoJcGFub3NlLTE6MiA0IDUgMyA1IDQgNiAzIDIgNDt9DQpAZm9udC1m YWNlDQoJe2ZvbnQtZmFtaWx5OkRlbmdYaWFuOw0KCXBhbm9zZS0xOjIgMSA2IDAgMyAxIDEgMSAx IDE7fQ0KQGZvbnQtZmFjZQ0KCXtmb250LWZhbWlseTpDYWxpYnJpOw0KCXBhbm9zZS0xOjIgMTUg NSAyIDIgMiA0IDMgMiA0O30NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6IlxARGVuZ1hpYW4i Ow0KCXBhbm9zZS0xOjIgMSA2IDAgMyAxIDEgMSAxIDE7fQ0KLyogU3R5bGUgRGVmaW5pdGlvbnMg Ki8NCnAuTXNvTm9ybWFsLCBsaS5Nc29Ob3JtYWwsIGRpdi5Nc29Ob3JtYWwNCgl7bWFyZ2luOjBp bjsNCglmb250LXNpemU6MTEuMHB0Ow0KCWZvbnQtZmFtaWx5OiJDYWxpYnJpIixzYW5zLXNlcmlm Ow0KCW1zby1saWdhdHVyZXM6c3RhbmRhcmRjb250ZXh0dWFsO30NCnNwYW4uRW1haWxTdHlsZTE3 DQoJe21zby1zdHlsZS10eXBlOnBlcnNvbmFsLWNvbXBvc2U7DQoJZm9udC1mYW1pbHk6IkNhbGli cmkiLHNhbnMtc2VyaWY7DQoJY29sb3I6d2luZG93dGV4dDt9DQouTXNvQ2hwRGVmYXVsdA0KCXtt c28tc3R5bGUtdHlwZTpleHBvcnQtb25seTt9DQpAcGFnZSBXb3JkU2VjdGlvbjENCgl7c2l6ZTo4 LjVpbiAxMS4waW47DQoJbWFyZ2luOjEuMGluIDEuMGluIDEuMGluIDEuMGluO30NCmRpdi5Xb3Jk U2VjdGlvbjENCgl7cGFnZTpXb3JkU2VjdGlvbjE7fQ0KLS0+PC9zdHlsZT48IS0tW2lmIGd0ZSBt c28gOV0+PHhtbD4NCjxvOnNoYXBlZGVmYXVsdHMgdjpleHQ9ImVkaXQiIHNwaWRtYXg9IjEwMjYi IC8+DQo8L3htbD48IVtlbmRpZl0tLT48IS0tW2lmIGd0ZSBtc28gOV0+PHhtbD4NCjxvOnNoYXBl bGF5b3V0IHY6ZXh0PSJlZGl0Ij4NCjxvOmlkbWFwIHY6ZXh0PSJlZGl0IiBkYXRhPSIxIiAvPg0K PC9vOnNoYXBlbGF5b3V0PjwveG1sPjwhW2VuZGlmXS0tPg0KPC9oZWFkPg0KPGJvZHkgbGluaz0i IzA1NjNDMSIgdmxpbms9IiM5NTRGNzIiIHN0eWxlPSJ3b3JkLXdyYXA6YnJlYWstd29yZCI+DQo8 ZGl2IGNsYXNzPSJXb3JkU2VjdGlvbjEiPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gbGFu Zz0iRU4tVVMiPkhpLCBJIG9ic2VydmVkIHNvbWUgZGlmZmVyZW5jZSBpbiBiZWhhdmlvciBmb3Ig Z3JhbnRpbmcgcm9sZXMuPG86cD48L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1h bCI+PHNwYW4gbGFuZz0iRU4tVVMiPjxvOnA+Jm5ic3A7PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNs YXNzPSJNc29Ob3JtYWwiPjxzcGFuIGxhbmc9IkVOLVVTIj5SdW5uaW5nIGFzIGEgc3VwZXJ1c2Vy IChwb3N0Z3JlcykuPG86cD48L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+ PHNwYW4gbGFuZz0iRU4tVVMiPjxvOnA+Jm5ic3A7PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNz PSJNc29Ob3JtYWwiPjxzcGFuIGxhbmc9IkVOLVVTIj5TUUw6PG86cD48L286cD48L3NwYW4+PC9w Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gbGFuZz0iRU4tVVMiPmNyZWF0ZSByb2xlIHRl c3RfZ3JvdXA7PG86cD48L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNw YW4gbGFuZz0iRU4tVVMiPmNyZWF0ZSByb2xlIHRlc3RfdXNlcjs8bzpwPjwvbzpwPjwvc3Bhbj48 L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBsYW5nPSJFTi1VUyI+Y3JlYXRlIHJvbGUg dGVzdF9zdSB3aXRoIHN1cGVydXNlcjs8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0i TXNvTm9ybWFsIj48c3BhbiBsYW5nPSJFTi1VUyI+Z3JhbnQgdGVzdF9ncm91cCB0byB0ZXN0X3Vz ZXIgZ3JhbnRlZCBieSB0ZXN0X3N1OzxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJN c29Ob3JtYWwiPjxzcGFuIGxhbmc9IkVOLVVTIj48bzpwPiZuYnNwOzwvbzpwPjwvc3Bhbj48L3A+ DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBsYW5nPSJFTi1VUyI+T3V0cHV0IG9uIFBHMTYg JmFtcDsgUEcxNzo8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48 c3BhbiBsYW5nPSJFTi1VUyI+Q1JFQVRFIFJPTEU8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBj bGFzcz0iTXNvTm9ybWFsIj48c3BhbiBsYW5nPSJFTi1VUyI+Q1JFQVRFIFJPTEU8bzpwPjwvbzpw Pjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBsYW5nPSJFTi1VUyI+Q1JF QVRFIFJPTEU8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3Bh biBsYW5nPSJFTi1VUyI+RVJST1I6Jm5ic3A7IHBlcm1pc3Npb24gZGVuaWVkIHRvIGdyYW50IHBy aXZpbGVnZXMgYXMgcm9sZSAmcXVvdDt0ZXN0X3N1JnF1b3Q7PG86cD48L286cD48L3NwYW4+PC9w Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gbGFuZz0iRU4tVVMiPkRFVEFJTDombmJzcDsg VGhlIGdyYW50b3IgbXVzdCBoYXZlIHRoZSBBRE1JTiBvcHRpb24gb24gcm9sZSAmcXVvdDt0ZXN0 X2dyb3VwJnF1b3Q7LjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwi PjxzcGFuIGxhbmc9IkVOLVVTIj48bzpwPiZuYnNwOzwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFz cz0iTXNvTm9ybWFsIj48c3BhbiBsYW5nPSJFTi1VUyI+VGhlIHNhbWUgc3VjY2VlZHMgb24gUEcx NS48bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBsYW5n PSJFTi1VUyI+PG86cD4mbmJzcDs8L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1h bCI+PHNwYW4gbGFuZz0iRU4tVVMiPlRoaXMgbGlrZWx5IGhhcyB0byBkbyB3aXRoIHdvcmsgdGhh dCB3YXMgZG9uZSBieSBSb2JlcnQgSGFhcyBvbiBpbnRyb2R1Y2luZyB0aGlzIEFETUlOIG9wdGlv biBpbiBQRzE2LjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxz cGFuIGxhbmc9IkVOLVVTIj5TdXJlbHkgZG9pbmcg4oCcZ3JhbnRlZCBieSBzb21lX3N1cGVydXNl cuKAnSBzaG91bGQgYmUgYWxsb3dlZCByZWdhcmRsZXNzIG9mIHRoZSBBRE1JTiBvcHRpb24gdGhv dWdoLCByaWdodD88bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48 c3BhbiBsYW5nPSJFTi1VUyI+PG86cD4mbmJzcDs8L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9 Ik1zb05vcm1hbCI+PHNwYW4gbGFuZz0iRU4tVVMiPi1GbG9yaXM8bzpwPjwvbzpwPjwvc3Bhbj48 L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBsYW5nPSJFTi1VUyI+PG86cD4mbmJzcDs8 L286cD48L3NwYW4+PC9wPg0KPC9kaXY+DQo8L2JvZHk+DQo8L2h0bWw+DQo= --_000_bc5f945cbd27483f83a59880550722ceOptivercom_--