DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition;
	b=g1CmLzuTJYNdE1KOKIsOtoeJLiCpBTHILHsnYgzWn51NjEIedaTF21i9NN7H9E35JW7nkm72hDpPlgKfxV6kp9wl88e7FatzQHzOziHwJRI9RXNF0fjWfVxEZc6JOam4MQMpneZeU2MOOb3TZu+TiLMv6CGbAZ/DkQRmzVBYFwc=
Message-ID: <ae830e6c05060309182201f85b@mail.gmail.com>
Date: Fri, 3 Jun 2005 11:18:25 -0500
From: David Hinkle <drachs@gmail.com>
Reply-To: David Hinkle <drachs@gmail.com>
To: pgsql-interfaces@postgresql.org
Subject: libpq, PQExecParams and the inserting of binary data
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

I have been trying to figure this out all morning, and I've gotten no
where so far.

I am trying to insert binary data into a bytea column with
PQExecParams.  I couldn't find any documentation on using PQExecParams
with binary parameters, do I tried to do it this way:

int _ma_logbody(struct MailData *MailData, char *bodyp, size_t bodylen)
    {
    const char *paramValues[2];
    char *text_body;
    PGresult   *res;
    size_t      newlen;

    text_body =3D PQescapeBytea(bodyp, bodylen, &newlen);

    paramValues[0] =3D MailData->MsgId;
    paramValues[1] =3D text_body;

    res =3D PQexecParams(conn, "insert into ma_body (msg_id, body)
VALUES ($1, $2);",
            2,       /* params */
            NULL,    /* let the backend deduce param type */
            paramValues,
            NULL,    /* don't need param lengths since text */
            NULL,    /* default to all text params */
            0);

    PQfreemem(text_body);

    if (PQresultStatus(res) !=3D PGRES_COMMAND_OK)
        {
        log(LOG_MAIL, "Postresql insert failed: %s", PQerrorMessage(conn));
        log(LOG_MAIL, "bodylen: %d, bodyp: %s", bodylen, bodyp);
        PQclear(res);
        PQfinish(conn);
        conn =3D NULL;
        return(0);
        }

    PQclear(res);

    return(TRUE);
    }

As you can see, I assumed I could use PQexapeBytea to escape the
binary data and then just use the returned value as a text parameter.=20
However,  I randomly get insert errors with the error message:=20
"invalid input syntax for type Bytea".

If anybody could help me find the right way to do this I'd really
apreciate it...