Postgresql assistance needed - Mailing list pgsql-general

From Sasmit Utkarsh
Subject Postgresql assistance needed
Date
Msg-id CAM-5MT3pqu+3xV6syK8wRF7HYCE9F_Z5U4Rwi7F+OHfDcfXeWQ@mail.gmail.com
Whole thread Raw
Responses Re: Postgresql assistance needed  (Laurenz Albe <laurenz.albe@cybertec.at>)
Re: Postgresql assistance needed  (Greg Sabino Mullane <htamfids@gmail.com>)
List 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@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
Attachment

pgsql-general by date:

Previous
From: Siddharth Jain
Date:
Subject: How do you optimize the disk IO when you cannot assume a file will start at a boundary then?
Next
From: Laurenz Albe
Date:
Subject: Re: Postgresql assistance needed