Re: Case sensitive grant statements in pg14?

Thanks,

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"

if I do the same with:
GRANT CREATE ON SCHEMA my_schema TO bob;

by hand and press return, it returns with "GRANT"

¯\_(ツ)_/¯

is seems very strange.

I don't know if that's the actual underlying error, or if throwing the
"syntax error at bob" is indicative of some other error.
I've never run across it before so I thought I would ask.

Thanks again,
rik.

On Thu, Dec 21, 2023 at 2:34 PM M Sarwar <sarwarmd02(at)outlook(dot)com> wrote:

> Richard Coleman,
> Based on Tom's email, here is my advise to you.
>
> Prepare all your commands and copy to a notepad.
> Now copy from the notepad and execute the commands and let us see if you
> get the same errors like in your first email.
>
> Thanks,
> Sarwar
>
> ------------------------------
> *From:* Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> *Sent:* Thursday, December 21, 2023 2:26 PM
> *To:* richard coleman <rcoleman(dot)ascentgl(at)gmail(dot)com>
> *Cc:* Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
> *Subject:* Re: Case sensitive grant statements in pg14?
>
> richard coleman <rcoleman(dot)ascentgl(at)gmail(dot)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
>
>
>