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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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