[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: Need assistance for running postgresql procedures
From:       Sasmit Utkarsh <utkarshsasmit () gmail ! com>
Date:       2024-01-24 4:56:52
Message-ID: CAM-5MT3MRDZoohzpwcUPifVwJWawJqRrRXV48XcxJZDbwtpF=Q () mail ! gmail ! com
[Download RAW message or body]

Thanks, I'll check it out.

Regards,
Sasmit Utkarsh
+91-7674022625

On Wed, 24 Jan, 2024, 01:59 Francisco Olarte, <folarte@peoplecall.com>
wrote:

> Hi sasmit.
>
> On Tue, 23 Jan 2024 at 18:51, Sasmit Utkarsh <utkarshsasmit@gmail.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.
>

[Attachment #3 (text/html)]

<div dir="auto">Thanks, I&#39;ll check it out.<br><br><div \
data-smartmail="gmail_signature">Regards,<br>Sasmit \
Utkarsh<br>+91-7674022625</div></div><br><div class="gmail_quote"><div dir="ltr" \
class="gmail_attr">On Wed, 24 Jan, 2024, 01:59 Francisco Olarte, &lt;<a \
href="mailto:folarte@peoplecall.com">folarte@peoplecall.com</a>&gt; \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex">Hi sasmit.<br> <br>
On Tue, 23 Jan 2024 at 18:51, Sasmit Utkarsh &lt;<a \
href="mailto:utkarshsasmit@gmail.com" target="_blank" \
rel="noreferrer">utkarshsasmit@gmail.com</a>&gt; wrote:<br> &gt; 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<br> <br>
I&#39;m not familiar with using binary parameters, but are you sured you<br>
do not need calling htonl(3) on the rtp value? ( 3 is man section, not<br>
htonl argument ).<br>
<br>
&quot;Values passed in binary format require knowledge of the internal<br>
representation expected by the backend.<br>
********* For example, integers must be passed in network byte order. ******<br>
  Passing numeric values requires knowledge of the server storage<br>
format, as implemented in<br>
src/backend/utils/adt/numeric.c::numeric_send() and<br>
src/backend/utils/adt/numeric.c::numeric_recv().&quot;<br>
<br>
A quick test would be to use rtp=0x04000000 and see if it then works (<br>
if it comes from cmd line or similar, if it comes from code just use<br>
hton )<br>
<br>
<br>
Francisco Olarte.<br>
</blockquote></div>



[prev in list] [next in list] [prev in thread] [next in thread]