Re: Postgresql assistance needed

2024-02-22 Thread Sasmit Utkarsh
Thanks, I'll check it out. Regards, Sasmit Utkarsh +91-7674022625 On Thu, 22 Feb, 2024, 21:40 Laurenz Albe, wrote: > On Thu, 2024-02-22 at 19:35 +0530, Sasmit Utkarsh wrote: > > Is there any configuration/query that can be checked to verify if > "shc_uadmin" has the correct path set? > > The S

Re: Postgresql assistance needed

2024-02-22 Thread Laurenz Albe
On Thu, 2024-02-22 at 19:35 +0530, Sasmit Utkarsh wrote: >  Is there any configuration/query that can be checked to verify if  > "shc_uadmin" has the correct path set? The SQL statement "SHOW search_path" would return the current setting. But look at the error message first. Yours, Laurenz Albe

Re: Postgresql assistance needed

2024-02-22 Thread Greg Sabino Mullane
On the surface, it looks as though it *should* work if the only thing changing is the username. Those other more serious errors should get fixed, but putting those aside for now... We don't know what your program does. Write a smaller one that just does a PQexec and calls nextval, then returns a pr

Re: Postgresql assistance needed

2024-02-22 Thread Sasmit Utkarsh
Thanks Laurenz ->To debug that, get the actual error message using PQerrorMessage(). That should tell you what is going on. -- will try to add the PQerrorMessage() in the logs ->Perhaps the sequence is not on your "search_path", and you should qualify the name with the schema. -- I have given t

Re: Postgresql assistance needed

2024-02-22 Thread Laurenz Albe
On Thu, 2024-02-22 at 17:18 +0530, Sasmit Utkarsh wrote: > Perhaps, the issue I wanted to highlight here is that I get the same entry > working > when I switch user to "pgddb_admin" and not when change user with same > privileges > as PGUSER "shc_uadmin" I get the message in the error log like >

Re: Postgresql assistance needed

2024-02-22 Thread Sasmit Utkarsh
Hi Laurenz/Postgresql Team, Perhaps, the issue I wanted to highlight here is that I get the same entry working when I switch user to *"pgddb_admin" *and not when change user with same privileges as PGUSER "*shc_uadmin" *I get the message in the error log like* "<3>3343433-[ERROR] SELECT nextval F

Re: Postgresql assistance needed

2024-02-22 Thread Laurenz Albe
On Thu, 2024-02-22 at 16:13 +0530, Sasmit Utkarsh wrote: > On Thu, Feb 22, 2024 at 2:20 PM Laurenz Albe wrote: > > On Thu, 2024-02-22 at 14:01 +0530, Sasmit Utkarsh wrote: > > > ==3343433==ERROR: AddressSanitizer: heap-buffer-overflow on address > > > 0xf337ba80 at pc 0xf795fcdd bp 0xff8a74d8 sp

Re: Postgresql assistance needed

2024-02-22 Thread Sasmit Utkarsh
Hi Laurenz, Sorry but are you talking about the export variables in the result? Regards, Sasmit Utkarsh +91-7674022625 On Thu, Feb 22, 2024 at 2:20 PM Laurenz Albe wrote: > On Thu, 2024-02-22 at 14:01 +0530, Sasmit Utkarsh wrote: > > ==3343433==ERROR: AddressSanitizer: heap-buffer-overflow on

Re: Postgresql assistance needed

2024-02-22 Thread Laurenz Albe
On Thu, 2024-02-22 at 14:01 +0530, Sasmit Utkarsh wrote: > ==3343433==ERROR: AddressSanitizer: heap-buffer-overflow on address > 0xf337ba80 at pc 0xf795fcdd bp 0xff8a74d8 sp 0xff8a70b0 > READ of size 4096 at 0xf337ba80 thread T0 >     #0 0xf795fcdc in __interceptor_memcpy > (/nix/store/3blqv6wzmw

Postgresql assistance needed

2024-02-22 Thread Sasmit Utkarsh
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" *whic