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 1rGPm1-00FC82-CM for pgsql-admin@arkaria.postgresql.org; Thu, 21 Dec 2023 20:36:05 +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 1rGPlz-00EMGY-Kr for pgsql-admin@arkaria.postgresql.org; Thu, 21 Dec 2023 20:36:03 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rGPly-00EMGP-V2 for pgsql-admin@lists.postgresql.org; Thu, 21 Dec 2023 20:36:03 +0000 Received: from mx0b-000e5c14.pphosted.com ([148.163.137.209]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rGPls-00BYYU-Ak for pgsql-admin@lists.postgresql.org; Thu, 21 Dec 2023 20:36:00 +0000 Received: from pps.filterd (m0206231.ppops.net [127.0.0.1]) by mx0a-000e5c14.pphosted.com (8.17.1.19/8.17.1.19) with ESMTP id 3BLHkMuJ009542; Thu, 21 Dec 2023 14:35:55 -0600 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=express-scripts.com; h=from : to : cc : date : message-id : references : in-reply-to : content-type : content-transfer-encoding : mime-version : subject; s=pod140124231234; bh=R0c5veKRMtwwSGxMdLbPcYbNjEUeORoezB3bD3U7iLQ=; b=dYZhVN5QSGXJCFKGLqiuTRmosOI0VSNA0uWkx1x1HARLw9Gmwfsk7Xll/rZHa10Jpga0 /UsgbyDTZUK4LrDuWypAt+ILYYP4fm44Z2JPDC0dhg72EfZG4K4KCAgloIB6t220IatJ Re8+zwVcp2lGPvJj/62zLuW4pk4Lt1xhQzT4y4cOSi6p02IFXkEs46oqsVwe/JWRhSS9 DC4r8BVu3RbTTmsSCmaAEgqWsbynQJ8///vsnQkMAlI0jdNuGADvEMBaR24IwMNKiUPg u5tspNgjVfF1mOesH459kp6Vw0gNIQyblyGkYz+CyNjOiUZ4TJ/oCu3PMz/ufjH+if3J fw== Received: from eiaappxp0012.gid.prd.globalcore.com (lyncav03.cigna.com [170.48.19.151]) by mx0a-000e5c14.pphosted.com (PPS) with ESMTPS id 3v483fvcby-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Thu, 21 Dec 2023 14:35:54 -0600 Received: from cvlappxp20755.internal.cigna.com (HELO PS2PW1012185.accounts.root.corp) ([10.36.52.91]) by EIAAPPXP0012.gid.prd.globalcore.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 21 Dec 2023 20:35:53 +0000 Received: from PS2PW1012186.accounts.root.corp (10.221.225.154) by PS2PW1012185.accounts.root.corp (10.221.225.153) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1258.27; Thu, 21 Dec 2023 15:35:53 -0500 Received: from PS2PW1012186.accounts.root.corp ([fe80::ddfb:faf8:59ca:a8ec]) by PS2PW1012186.accounts.root.corp ([fe80::ddfb:faf8:59ca:a8ec%6]) with mapi id 15.02.1258.027; Thu, 21 Dec 2023 15:35:53 -0500 From: "Wetmore, Matthew (CTR)" To: Tom Lane , richard coleman CC: M Sarwar , Pgsql-admin Thread-Topic: [EXTERNAL] Re: Case sensitive grant statements in pg14? Thread-Index: AQHaNETP2pNqzxLK9ESXjxJgr4r99rC0eV2AgAAE1oD//7OtoA== Date: Thu, 21 Dec 2023 20:35:52 +0000 Message-ID: References: <796632.1703183786@sss.pgh.pa.us> <832930.1703186786@sss.pgh.pa.us> <915592.1703189307@sss.pgh.pa.us> In-Reply-To: <915592.1703189307@sss.pgh.pa.us> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.222.252.1] x-proofpoint-routing: 000e5c14 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-CFilter-Loop: Reflected Subject: Case sensitive grant statements in pg14? X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.272,Aquarius:18.0.997,Hydra:6.0.619,FMLib:17.11.176.26 definitions=2023-12-21_09,2023-12-21_02,2023-05-22_02 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PG 13.11 checking in here. psql=3D> grant create on schema my_schema to mwetmore; GRANT psql=3D> grant create, usage on schema my_schema to mwetmore; GRANT -----Original Message----- From: Tom Lane =20 Sent: Thursday, December 21, 2023 12:08 PM To: richard coleman Cc: M Sarwar ; Pgsql-admin Subject: [EXTERNAL] Re: Case sensitive grant statements in pg14? richard coleman writes: > But there is no Copy/Pasting involved. > if I open a psql prompt on my Ubuntu server. > type: > grant create on schema my_schema to bob; > by hand and press return, it replies with the error messages about a=20 > syntax error at "bob" All I can say is it works for me, and I can't tell from here what's differe= nt on your end. regards, tom lane