Re: Need assistance for running postgresql procedures

Hi sasmit.

On Tue, 23 Jan 2024 at 18:51, Sasmit Utkarsh <utkarshsasmit(at)gmail(dot)com> wrote:
> 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

I'm not familiar with using binary parameters, but are you sured you
do not need calling htonl(3) on the rtp value? ( 3 is man section, not
htonl argument ).

"Values passed in binary format require knowledge of the internal
representation expected by the backend.
********* For example, integers must be passed in network byte order. ******
Passing numeric values requires knowledge of the server storage
format, as implemented in
src/backend/utils/adt/numeric.c::numeric_send() and
src/backend/utils/adt/numeric.c::numeric_recv()."

A quick test would be to use rtp=0x04000000 and see if it then works (
if it comes from cmd line or similar, if it comes from code just use
hton )

Francisco Olarte.