Postgresql assistance needed

From: Sasmit Utkarsh <utkarshsasmit(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Postgresql assistance needed
Date: 2024-02-22 08:31:56
Message-ID: CAM-5MT3pqu+3xV6syK8wRF7HYCE9F_Z5U4Rwi7F+OHfDcfXeWQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)cucmtpccu1 ~]$ psql "host=
cucmpsgsu0.postgres.database.azure.com
<http://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

Attachment Content-Type Size
success_log.txt text/plain 32.4 KB
Error_log.txt text/plain 36.8 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2024-02-22 08:50:30 Re: Postgresql assistance needed
Previous Message Siddharth Jain 2024-02-22 01:22:47 How do you optimize the disk IO when you cannot assume a file will start at a boundary then?