Hi Postgresql Team,
I'm facing a weird issue which testing the application code using libpq in C. when i run a test case with PGUSER as "pgddb_admin" i get the expected result (more details attached in success_log doc) whereas when i run the same test case using another user "shc_uadmin" which has same privileges, I get below error message highlighted(more details in Error_log doc attached)
<3>3343433-[ERROR] SELECT nextval Failed [../tpfasm.c:3561:get_pool_fa]
More details related to "
shc_uadmin" and sequence
"unassigned_pool_fa" which is present in non-public schema
(shc) below from the terminal.
[shc_user@cucmtpccu1 ~]$ psql "host= cucmpsgsu0.postgres.database.azure.com port=5432 dbname=mshcd user=shc_uadmin password=abc123 sslmode=require options=--search_path=shc,public"
psql (16.1, server 15.4)
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, compression: off)
Type "help" for help.
mshcd=> \dp unassigned_pool_fa
Access privileges
Schema | Name | Type | Access privileges | Column privileges | Policies
--------+--------------------+----------+-----------------------------+-------------------+----------
shc | unassigned_pool_fa | sequence | pgddb_admin=rwU/pgddb_admin+| |
| | | shc_uadmin=rwU/pgddb_admin | |
(1 row)
mshcd=> SELECT nextval('unassigned_pool_fa');
nextval
-------------
-1811939322
(1 row)
Is there any other issue related to the permissions or configuration associated with the shc_uadmin user in PostgreSQL which needs to be checked/verified? Please assist with your inputs
Regards,
Sasmit Utkarsh
+91-7674022625