Re: insertion of bytea - Mailing list pgsql-performance

From Tom Lane
Subject Re: insertion of bytea
Date
Msg-id 13782.1130250200@sss.pgh.pa.us
Whole thread Raw
In response to insertion of bytea  ("Chris Mair" <list@1006.org>)
Responses Re: insertion of bytea  ("Chris Mair" <list@1006.org>)
List pgsql-performance
"Chris Mair" <list@1006.org> writes:
> Am I correct in assuming that even though I'm passing my 52000
> bytes as a (char *) to PQexecPrepared(), encoding/decoding is
> happening (think 0 -> \000) somewhere in the transfer?

Are you specifying it as a text or binary parameter?  Have you looked to
see if the stored data is what you expect?

            regards, tom lane

pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Reindex - Is this necessary after a vacuum?
Next
From: Tom Lane
Date:
Subject: Re: Reindex - Is this necessary after a vacuum?