From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: therealgofman@mail.ru
Subject: BUG #18545: \dt breaks transaction, calling error when executed in SET SESSION AUTHORIZATION
Date: Fri, 19 Jul 2024 09:25:11 +0000
Message-ID: <18545-feba138862f19aaa@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18545
Logged by: Andrey Rachitskiy
Email address: therealgofman@mail.ru
PostgreSQL version: 16.3
Operating system: Debian 12
Description:
\dt breaks transaction, calling error when executed in SET SESSION
AUTHORIZATION. This happens in two cases, with different SET.
Case one:
postgres@debian-test:~$ psql -U postgres
psql (16.3)
Type "help" for help.
postgres=# \set VERBOSITY verbose
postgres=# BEGIN;
BEGIN
postgres=*# CREATE USER regress_priv_user8;
CREATE ROLE
postgres=*# SET SESSION AUTHORIZATION regress_priv_user8;
SET
postgres=*> \dt+;
Did not find any relations.
postgres=*> SET LOCAL debug_parallel_query = 1;
SET
postgres=*> \dt+;
ERROR: 22023: role "regress_priv_user8" does not exist
CONTEXT: while setting parameter "session_authorization" to
"regress_priv_user8"
parallel worker
LOCATION: call_string_check_hook, guc.c:6734
postgres=!#
\q
Case two:
postgres@debian-test:~$ psql -U postgres
psql (16.3)
Type "help" for help.
postgres=# \set VERBOSITY verbose
postgres=# BEGIN;
BEGIN
postgres=*# CREATE USER regress_priv_user8;
CREATE ROLE
postgres=*# SET SESSION AUTHORIZATION regress_priv_user8;
SET
postgres=*> \dt+
Did not find any relations.
postgres=*> set local parallel_setup_cost = 0;
SET
postgres=*> set local min_parallel_table_scan_size = 0;
SET
postgres=*> \dt+
ERROR: 22023: role "regress_priv_user8" does not exist
CONTEXT: while setting parameter "session_authorization" to
"regress_priv_user8"
parallel worker
LOCATION: call_string_check_hook, guc.c:6734
postgres=!#
\q
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-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, therealgofman@mail.ru
Subject: Re: BUG #18545: \dt breaks transaction, calling error when executed in SET SESSION AUTHORIZATION
In-Reply-To: <18545-feba138862f19aaa@postgresql.org>
* 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