Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group