Re: Case sensitive grant statements in pg14? - Mailing list pgsql-admin

From richard coleman
Subject Re: Case sensitive grant statements in pg14?
Date
Msg-id CAGA3vBu7niL0NVP1w__94qvURN9nUyvcA+q4iUjFHwxtCEeUbA@mail.gmail.com
Whole thread Raw
In response to Re: Case sensitive grant statements in pg14?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tom,
Thanks for the suggestion.  As mentioned previously restarting the postgresql service seems to have fixed the issue.  Which would tend to rule out terminal issues.
If it happens again, I'll try the "log_statement = 'all' " setting and see if anything untold revels itself.

Until the next bought of weirdness...
rik.

On Thu, Dec 21, 2023 at 3:43 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Joe Conway <mail@joeconway.com> writes:
> 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?

Theoretically, if the example is all-ASCII, that shouldn't matter.
But for sure there is something weird happening.

One idea for investigation is to set log_statement = 'all' and
then see how the troublesome command shows up in the postmaster log.

                        regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Case sensitive grant statements in pg14?
Next
From: Carlos Alves
Date:
Subject: Re: Error: Package: postgresql13-devel-13.13-1PGDG.rhel7.x86_64