Re: insertion of bytea

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Chris Mair" <list(at)1006(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: insertion of bytea
Date: 2005-10-25 14:23:20
Message-ID: 13782.1130250200@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Chris Mair" <list(at)1006(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-10-25 14:27:08 Re: Reindex - Is this necessary after a vacuum?
Previous Message Richard Huxton 2005-10-25 14:16:27 Re: Reindex - Is this necessary after a vacuum?