From: Tom Lane <tgl@sss.pgh.pa.us>
To: richard coleman <rcoleman.ascentgl@gmail.com>
cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Case sensitive grant statements in pg14?
In-reply-to: 
 <CAGA3vBvWwg21=YawST0AA5-_Gd-niCMnxrORN7=Pj_-nT_MP+Q@mail.gmail.com>
References: 
 <CAGA3vBua6YVJBDKfsaE51U6X0fO5bRfvOtsLFSd+KTy3J95LtA@mail.gmail.com>
 <796632.1703183786@sss.pgh.pa.us>
 <CAGA3vBvWwg21=YawST0AA5-_Gd-niCMnxrORN7=Pj_-nT_MP+Q@mail.gmail.com>
Comments: In-reply-to richard coleman <rcoleman.ascentgl@gmail.com>
	message dated "Thu, 21 Dec 2023 13:45:38 -0500"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <832929.1703186786.1@sss.pgh.pa.us>
Date: Thu, 21 Dec 2023 14:26:26 -0500
Message-ID: <832930.1703186786@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/832930.1703186786%40sss.pgh.pa.us>
Precedence: bulk

richard coleman <rcoleman.ascentgl@gmail.com> writes:
> I am having instances of (substituting example names for schema and role):
>  grant create, usage on schema my_schema to bob;

> returning the error message:
> ERROR: syntax error at or near "bob"

> but:
> GRANT CREATE, USAGE ON SCHEMA my_schema TO bob;

> succeeding.

> I hope that's clearer.

Well, it's clearer, but I don't believe it.  What I think is
far more likely an explanation is that you've got some weird
non-ASCII whitespace in the first version of the command.
Copying-and-pasting from your mail doesn't show anything
strange though.

			regards, tom lane