From: | Chris Nicholas <cgn(at)globexplorer(dot)com> |
---|---|
To: | pgsql-interfaces(at)postgreSQL(dot)org |
Subject: | dynamic large objects <-> C procs; HOWTO? |
Date: | 2000-08-23 06:19:52 |
Message-ID: | 200008230619.XAA02372@chis.globexplorer.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
Greetings -
I was wondering what the best manner of transferring large objects to
and from user-defined "C" functions through the JDBC or libpq interfaces
might be. These objects are mostly transient query results, and shouldn't
be stored on the file system; they are really transcoded imagery, audio,
etc formatted on the fly to the user's specifications.
I've looked a bit at the lo interfaces, and it seems that (appropriately)
everything is geared towards commit/rollback within the executor, such
that things are allocated in palloc(), or one gets and oid and sticks
stuff into the file system.
But is there a way for a user-defined process to somehow support a
read(2) and/or a write(2) type of interface via the fastpath mechanisms,
given the caveat that these things are outside of transactional control?
suggestions/comments/flames welcome.
Chris Nicholas
From | Date | Subject | |
---|---|---|---|
Next Message | Christophe Vigny | 2000-08-23 14:09:20 | odbc |
Previous Message | Constantin Teodorescu | 2000-08-23 06:03:47 | Re: applet-servlet and pgaccess |