Best Practices for Managing Schema Changes Dynamically with libpq

application and database in sync dynamically? I would appreciate any guidance, patterns, or examples that can help us implement a robust solution. Thank you for your time and support! Regards, Sasmit Utkarsh +91-7674022625

Re: Assistance Required: Timeout or Buffer Overflow Issue in PostgreSQL Client Application

170ad start_thread (libc.so.6) #34 0xf6bb1dea __clone (libc.so.6) Regards, Sasmit Utkarsh +91-7674022625 On Thu, Oct 24, 2024 at 9:47 PM Igor Korot wrote: > Hi, > Is this a complete backtrace? > Can you post a complete

Assistance Required: Timeout or Buffer Overflow Issue in PostgreSQL Client Application

tance with troubleshooting this would be highly appreciated. Regards, Sasmit Utkarsh +91-7674022625 void checkLOCK(int32_t fa) { int nFields; int nTuples; int i, j; PGresult *checkLOCK_res=NULL; char Command[100]; LOG_TRACE("%s() fa(%i)(%08X)&

Re: Stess test via libpq for postgreSQL DB

Thanks David Regards, Sasmit Utkarsh +91-7674022625 On Sat, Apr 27, 2024 at 11:44 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Sat, Apr 27, 2024 at 11:07 AM Sasmit Utkarsh > wrote: > >> >> But i have some clarifications if we can use it to e

Stess test via libpq for postgreSQL DB

blocks rather than standalone SQL queries. Please advise Regards, Sasmit Utkarsh +91-7674022625

Re: Need some assistance on stored procedures execution using libpq in C

Hi Pavel, Thanks for the info. But is it not possible to have some kind of handling of an empty result set using libpq for the given procedure? Regards, Sasmit Utkarsh +91-7674022625 On Thu, Apr 25, 2024 at 8:26 PM Pavel Stehule wrote: > Hi > > čt 25. 4. 2024 v 12:57 odesílat

Need some assistance on stored procedures execution using libpq in C

| publicName| sql_update_data_procedureResult data type|Argument data types | indata bytea, unhold boolean, fa integerType| proc* Regards, Sasmit Utkarsh +91-7674022625 /*** stored Procedure: CREATE OR REPLACE PROCEDURE sql_select_data_procedure( fa integer

Re: Assistance needed for the query execution in non-public schema

Thanks Laurenz and David Regards, Sasmit Utkarsh +91-7674022625 On Tue, 16 Apr, 2024, 16:58 Laurenz Albe, wrote: > On Tue, 2024-04-16 at 16:30 +0530, Sasmit Utkarsh wrote: > > msshctd=> SELECT setval(pg_get_serial_sequence('mqa_flfo_cstr', 'id'), > coale

Assistance needed for the query execution in non-public schema

seq TO shc_uadmin; *ERROR: unrecognized privilege type "alter" SQL state: 42601* Is there any other way i can execute the queries, with user *"shc_uadmin"* for the *setval()* to work properly without giving complete privileges same as the owner *"pgddb_admin"* ? Any workaround/ alternate option which would work here? Please assist Regards, Sasmit Utkarsh +91-7674022625

Re: Need Assistance: Command to display procedures does not work

switching between different DBs and machines got my mind diverted [image: image.png] Regards, Sasmit Utkarsh +91-7674022625 On Wed, Feb 28, 2024 at 10:50 PM Adrian Klaver wrote: > On 2/28/24 09:13, Sasmit Utkarsh wrote: > > Reply to list also > Ccing list > > HI Adrian,

Re: Need Assistance: Command to display procedures does not work

shc_data-> shc_data-> ^C shc_data=> SHOW search_path; search_path - "$user", public (1 row) shc_data=> Regards, Sasmit Utkarsh +91-7674022625 On Wed, Feb 28, 2024 at 10:43 PM Adrian Klaver wrote: > On 2/28/24 09:08, Sasmit Utkarsh wrote: > > Thanks Rob

Re: Need Assistance: Command to display procedures does not work

size_procedure | sql_select_data_procedure | *sql_insert_data_procedure* | sql_update_data_procedure | (4 rows) shc_data=> DROP PROCEDURE *sql_insert_data_procedure*; ERROR: could not find a procedure named "sql_insert_data_procedure" shc_data=> Regards, Sasmit Utkarsh +91-7674022625 On Wed, Feb

Re: Need Assistance: Command to display procedures does not work

ata_procedure | (4 rows) but when I try to connect to the same db on PgAdmin4, I don't see the list even after refresh. Why is that different? [image: image.png] Regards, Sasmit Utkarsh +91-7674022625 On Wed, Feb 28, 2024 at 9:33 PM Adrian Klaver wrote: > On 2/28/24 07:53, Sasmit Utk

Need Assistance: Command to display procedures does not work

ect_data_procedure | sql_insert_data_procedure | sql_update_data_procedure | (4 rows) Regards, Sasmit Utkarsh +91-7674022625

Re: Clarity regarding the procedures call in postgresql for public and non-public schema

0] = 25; // {text} SelectSizeParamTypes[1] = 23; // {int} The point here I'm trying to make is that the same procedure is called with similar inputs in the earlier mail, But it is getting executed for 1 user i.e "pgddb_admin"(admin user) but not for *shc_uadmin. * Regards, Sasmi

Clarity regarding the procedures call in postgresql for public and non-public schema

dmin user), even though there are no changes in the inputs for the procedure call, just changing the user is throwing me above error. Is there any configuration change that needs to be verified for the "shc_uadmin" user as part of procedures? or whether the procedures are created by once user cannot be executed/called by another. What are all the pointers here that need to be checked to resolve this issue? Kindly assist Regards, Sasmit Utkarsh +91-7674022625

Re: Postgresql assistance needed

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 th

Re: Postgresql assistance needed

PGHOST=cucmpsgsu0.postgres.database.azure.com export PGDATABASE=mshcd *export PGUSER=shc_uadmin* export PGPASSWORD=abc123 export PGOPTIONS='--search_path=*shc,shc_tty,public*' Regards, Sasmit Utkarsh +91-7674022625 On Thu, Feb 22, 2024 at 7:11 PM Laurenz Albe wrote: > On Thu, 2

Re: Postgresql assistance needed

PQclear(res); 3565 return 0; 3566 } Is the issue related to configuration of PGUSER or something else Regards, Sasmit Utkarsh +91-7674022625 On Thu, Feb 22, 2024 at 4:20 PM Laurenz Albe wrote: > On Thu, 2024-02-22 at 16:

Re: Postgresql assistance needed

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

Postgresql assistance needed

|(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 wit

Re: Clarification regarding managing advisory locks in postgresql

e know if you need any more details or clarfications Regards, Sasmit Utkarsh +91-7674022625 On Thu, Jan 25, 2024 at 10:42 AM Christophe Pettus wrote: > > > > On Jan 24, 2024, at 19:17, Sasmit Utkarsh > wrote: > > > > Need your support on understanding advisory locks

Clarification regarding managing advisory locks in postgresql

program using libpq in C explaining the above scenario if possible Regards, Sasmit Utkarsh +91-7674022625

Re: Need assistance for running postgresql procedures

Thanks, I'll check it out. Regards, Sasmit Utkarsh +91-7674022625 On Wed, 24 Jan, 2024, 01:59 Francisco Olarte, wrote: > Hi sasmit. > > On Tue, 23 Jan 2024 at 18:51, Sasmit Utkarsh > wrote: > > Kindly assist with the issue faced while calling procedures on > post

Need assistance for running postgresql procedures

Hi Postgres Team, Kindly assist with the issue faced while calling procedures on postgresql using libpq in C. I have attached all the details in the note. Please let me know if you need any more information Regards, Sasmit Utkarsh +91-7674022625 In general code flow: main

Re: Help needed for the resolution of memory leak

ok Thanks Merlin, I will go through the above specified doc and get back in case of further questions Regards, Sasmit Utkarsh +91-7674022625 On Thu, Jan 18, 2024 at 6:36 AM Merlin Moncure wrote: > On Wed, Jan 17, 2024 at 1:14 PM Sasmit Utkarsh > wrote: > >> Hi Merlin et al.

Re: Help needed for the resolution of memory leak

Thanks, I'll take a look. Regards, Sasmit Utkarsh +91-7674022625 On Wed, Jan 17, 2024 at 4:12 AM Merlin Moncure wrote: > On Tue, Jan 16, 2024 at 9:10 AM Sasmit Utkarsh > wrote: > >> Hi Merlin et al. >> >> I have tried to have the above change added in the mis

Re: Assitance needed for the resolution of memory leak

Thanks Tom, It did work, and yeah I do have indentation in my editor, there was some formatting issue due to the copy and paste of the code. :) Regards, Sasmit Utkarsh +91-7674022625 On Thu, Oct 12, 2023 at 2:07 AM Tom Lane wrote: > Sasmit Utkarsh writes: > > Like for an ex: I have

Re: Assitance needed for the resolution of memory leak

printf(stderr,"ERROR: %s\n",PQresultErrorMessage(res)); PQclear(res); } else { rc = 0; if ( sql_debug ) { fprintf(stderr,"INSERT SUCCESSFUL\n"); } PQclear(res); } if ( sql_debug1 ) { printPostgreSQL_SELECT_results(fa,conn); } return rc; } Regards, Sasmit Utkarsh +91-7674022625 On Th

Assitance needed for the resolution of memory leak

Hi Team, I'm trying to insert multiple duplicate rows into the table using libpq in C. I'm getting a memory leak reported from addresssanitizer tool. Please let me know if i can share the code snippet Regards, Sasmit Utkarsh +91-7674022625