From: Wetmore, Matthew (CTR) <Matthew.Wetmore@express-scripts.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
To: richard coleman <rcoleman.ascentgl@gmail.com>
Cc: M Sarwar <sarwarmd02@outlook.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Case sensitive grant statements in pg14?
Date: Thu, 21 Dec 2023 20:35:52 +0000
Message-ID: <dcbff223679c4c45b7eb18b840914758@express-scripts.com> (raw)
In-Reply-To: <915592.1703189307@sss.pgh.pa.us>
References: <CAGA3vBua6YVJBDKfsaE51U6X0fO5bRfvOtsLFSd+KTy3J95LtA@mail.gmail.com>
<796632.1703183786@sss.pgh.pa.us>
<CAGA3vBvWwg21=YawST0AA5-_Gd-niCMnxrORN7=Pj_-nT_MP+Q@mail.gmail.com>
<832930.1703186786@sss.pgh.pa.us>
<DM4PR19MB5978A3CB27D4267D16BD5DD5D395A@DM4PR19MB5978.namprd19.prod.outlook.com>
<CAGA3vBuVF0wk76qs_7yReNzbELRuT7LKokrc=WcO4jxmQVNgGQ@mail.gmail.com>
<915592.1703189307@sss.pgh.pa.us>
PG 13.11 checking in here.
psql=> grant create on schema my_schema to mwetmore;
GRANT
psql=> grant create, usage on schema my_schema to mwetmore;
GRANT
-----Original Message-----
From: Tom Lane <tgl@sss.pgh.pa.us>
Sent: Thursday, December 21, 2023 12:08 PM
To: richard coleman <rcoleman.ascentgl@gmail.com>
Cc: M Sarwar <sarwarmd02@outlook.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: [EXTERNAL] Re: Case sensitive grant statements in pg14?
richard coleman <rcoleman.ascentgl@gmail.com> 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
> syntax error at "bob"
All I can say is it works for me, and I can't tell from here what's different on your end.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Matthew.Wetmore@express-scripts.com, tgl@sss.pgh.pa.us, rcoleman.ascentgl@gmail.com, sarwarmd02@outlook.com, pgsql-admin@lists.postgresql.org
Subject: Re: Case sensitive grant statements in pg14?
In-Reply-To: <dcbff223679c4c45b7eb18b840914758@express-scripts.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox