From: pacquet@newsguy.com
To: tgl@sss.pgh.pa.us
To: pgsql-interfaces@postgresql.org
Subject: Re: PQputline in BINARY mode?
Date: Tue, 13 Aug 2002 15:15:11 -0700 (PDT)
Message-ID: <200208132215.PAA79633@newsguy.com> (raw)
Thanks. Now I realize what should have been obvious: the command "COPY
BINARY" is being executed by the backend, while PQputline() is a frontend
routine. Duh.
However, this is an embedded system, so some modest amount of backend-hacking
is quite acceptable if the payoff is large enough. Do you have any pointers on
implementing a variant of COPY BINARY <> FROM file that works out of memory
instead of a file?
At Tue, 13 Aug 2002 17:53:44 -0400, you wrote
>pacquet@newsguy.com writes:
>> the question is, can I combine both techniques, and use a programmatic
>> interface to copy binary information?
>
>Nope. There's no support for binary COPY in the frontend/backend
>protocol. This is one of the things I'd like to see fixed next time
>we change the protocol. (That's a sufficiently painful thing that we
>don't do it often --- the last time was release 6.4 --- but we're
>considering a protocol rev for the next development cycle, 7.4.)
>
> regards, tom lane
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: pacquet@newsguy.com, tgl@sss.pgh.pa.us
Subject: Re: PQputline in BINARY mode?
In-Reply-To: <200208132215.PAA79633@newsguy.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox