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 |
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? |