pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Joe Conway <mail@joeconway.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: Re: Case sensitive grant statements in pg14?
Date: Thu, 21 Dec 2023 15:39:30 -0500
Message-ID: <4081461a-e18c-4653-8221-35b1e627a4ee@joeconway.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>

On 12/21/23 15:08, Tom Lane wrote:
> 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.

I forget the specifics, but I have seen issues before if the terminal 
encoding and client encoding don't match. Could it be something like that?

-- 
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com






view thread (13+ messages)  latest in thread

Message-ID: <4081461a-e18c-4653-8221-35b1e627a4ee@joeconway.com>
Permalink:  ../4081461a-e18c-4653-8221-35b1e627a4ee@joeconway.com/
Also on:    postgresql.org/message-id/4081461a-e18c-4653-8221-35b1e627a4ee@joeconway.com

 · 

reply
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: mail@joeconway.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: <4081461a-e18c-4653-8221-35b1e627a4ee@joeconway.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