Postgresql assistance needed
От | Sasmit Utkarsh |
---|---|
Тема | Postgresql assistance needed |
Дата | |
Msg-id | CAM-5MT3pqu+3xV6syK8wRF7HYCE9F_Z5U4Rwi7F+OHfDcfXeWQ@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Postgresql assistance needed
Re: Postgresql assistance needed |
Список | pgsql-general |
Hi Postgresql Team,
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)
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
Вложения
В списке pgsql-general по дате отправления: