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: (view raw, whole thread or download thread mbox)
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-2017 The PostgreSQL Global Development Group