Postgres Pro
Downloads
Home   >   mailing lists

Thread: binding 64-bit integer

binding 64-bit integer

From
"flying2001us@yahoo.com"
Date:
Hi all,

I'm using Solaris 10 with 64-bit libpq library.

I wanted to bind a 64-bit integer, but it failed:
"ERROR:  incorrect binary data format in bind
parameter 1".

The code would succeed if the type of "val" is
uint32_t.

Doe anyone know how to fix this?  Thanks a lot!

-------------------------------------------------------------------------------------------------
uint64_t  val;
const char      *paramValues[1];
int  paramLengths[1];
int  paramFormats[1];
const char *sql_clause = "SELECT * FROM mytable  WHERE
mykey = $1";

paramValues[0] = (char *) &val;
paramLengths[0] = sizeof(val);
paramFormats[0] = 1;

res = PQexecParams(conn, sql_clause, 1, NULL,
          paramValues, paramLengths, paramFormats, 1);



__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Re: binding 64-bit integer

From
"Martin Gainty"
Date:
Flying-
reading the source displays
http://doxygen.postgresql.org/postgres_8c-source.html

       /* Trouble if it didn't eat the whole buffer */
                 if (!isNull && pbuf.cursor != pbuf.len)
                     ereport(ERROR,
                             (errcode(ERRCODE_INVALID_BINARY_REPRESENTATION),
                              errmsg("incorrect binary data format in bind
parameter %d",
                                     paramno + 1)));

the test is
  StringInfoData pbuf;

http://doxygen.postgresql.org/structStringInfoData.html#42669853a3faef1df41850bfd686cb24

pbuf.cursor (plain 32 bit int) != pbuf.len(64)

i think you found a bug....

M-
This email message and any files transmitted with it contain confidential
information intended only for the person(s) to whom this email message is
addressed.  If you have received this email message in error, please notify
the sender immediately by telephone or email and destroy the original
message without making a copy.  Thank you.

----- Original Message -----
From: <flying2001us@yahoo.com>
To: <pgsql-general@postgresql.org>
Sent: Thursday, April 19, 2007 9:02 PM
Subject: [GENERAL] binding 64-bit integer


> Hi all,
>
> I'm using Solaris 10 with 64-bit libpq library.
>
> I wanted to bind a 64-bit integer, but it failed:
> "ERROR:  incorrect binary data format in bind
> parameter 1".
>
> The code would succeed if the type of "val" is
> uint32_t.
>
> Doe anyone know how to fix this?  Thanks a lot!
>
> -------------------------------------------------------------------------------------------------
> uint64_t  val;
> const char      *paramValues[1];
> int  paramLengths[1];
> int  paramFormats[1];
> const char *sql_clause = "SELECT * FROM mytable  WHERE
> mykey = $1";
>
> paramValues[0] = (char *) &val;
> paramLengths[0] = sizeof(val);
> paramFormats[0] = 1;
>
> res = PQexecParams(conn, sql_clause, 1, NULL,
>          paramValues, paramLengths, paramFormats, 1);
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

Re: binding 64-bit integer

From
Tom Lane
Date:
"flying2001us@yahoo.com" <flying2001us@yahoo.com> writes:
> I wanted to bind a 64-bit integer, but it failed:
> "ERROR:  incorrect binary data format in bind
> parameter 1".

It sorta looks like you are trying to send that value to a parameter
that the server doesn't think is int8.

            regards, tom lane

Re: binding 64-bit integer

From
"flying2001us@yahoo.com"
Date:
After change the SQL clause to "SELECT * from mytable WHERE mykey=$1::int8", the binding passed!

Thanks for everyone's reply.

----- Original Message ----
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "flying2001us@yahoo.com" <flying2001us@yahoo.com>
Cc: pgsql-general@postgresql.org
Sent: Thursday, April 19, 2007 8:41:22 PM
Subject: Re: [GENERAL] binding 64-bit integer


"flying2001us@yahoo.com" <flying2001us@yahoo.com> writes:
> I wanted to bind a 64-bit integer, but it failed:
> "ERROR:  incorrect binary data format in bind
> parameter 1".

It sorta looks like you are trying to send that value to a parameter
that the server doesn't think is int8.

            regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Re: binding 64-bit integer

From
Tom Lane
Date:
"flying2001us@yahoo.com" <flying2001us@yahoo.com> writes:
> After change the SQL clause to "SELECT * from mytable WHERE mykey=$1::int8", the binding passed!

If you had to insert an explicit cast, it means that "mykey" isn't int8,
which makes one wonder why you are bothering.

            regards, tom lane