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

Re: insertion of bytea

From: "Chris Mair" <list(at)1006(dot)org>
To: <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <list(at)1006(dot)org>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: insertion of bytea
Date: 2005-10-25 21:41:47
Message-ID: 19131.82.58.59.118.1130276507.squirrel@www.endian.it (view raw or flat)
Thread:
Lists: pgsql-performance
>> 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?

I'm specifying it as binary (i.e. one's in PQexecPrepared's
format parameter). The stored data is correct.

I'll try "copy from stdin with binary" tomorrow and see what
I get...

Thanks & Bye, Chris.



In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2005-10-25 22:03:00
Subject: Re: Outer join query plans and performance
Previous:From: Chris MairDate: 2005-10-25 21:36:02
Subject: Re: insertion of bytea

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