nonblocking libpq large object access?

[David Helgason]

I was just wondering whether this was either:
- supported, or
- doable, either
- using the normal poll-read-done? loop
- a settable timeout

It would be awfully nice.

David Helgason,
Over the Edge Entertainments
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

[Tom Lane]

David Helgason <da***@uti.is> writes:

I was just wondering whether this was either:
- supported, or
- doable,

AFAIK no one has tried to make it work. Offhand it seems you'd need
to modify the API for libpq's LO operations in order to handle this.

A workaround you could think about is invoking the LO functions via
ordinary SELECT commands, ignoring libpq's LO API altogether. This
would have been rather painful in pre-7.4 releases since you'd have
to be willing to deal with quoting and dequoting "bytea" values, but
as of 7.4 you could use PQsendQueryParams() and specify binary format
for the bytea inputs and results.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[David Helgason]

On 15. feb 2004, at 18:18, Tom Lane wrote:

A workaround you could think about is invoking the LO functions via
ordinary SELECT commands, ignoring libpq's LO API altogether. This
would have been rather painful in pre-7.4 releases since you'd have
to be willing to deal with quoting and dequoting "bytea" values, but
as of 7.4 you could use PQsendQueryParams() and specify binary format
for the bytea inputs and results.

I think I'll go down that road provided it's not a performance killer.

I'll also be considering using a custom perl-socket-server system I
implemented for kicks (it's put up at
http://uti.is/david/320_maintserver_procs.sql, BSD license). It does
gzip of the steam for free, which is a win.

d.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org