Hi,
I've sort of solved the problem for me. I'm now doing one single
lo_read() to fetch the bytea field. Those functions do not operate on
the large object OID, but one needs to open them first with lo_open().
I'm doing another hack to get the size of the large object.
All combined in a sql
Hi,
I'm using the function below to convert a large object to a bytea value.
Unfortunately, it performs very poorly for *large* objects, i.e. I'm
currently fiddling with a file of about 100 MB.
I've increased work_mem to 256 MB, but that didn't help much. I suspect
the aggregate function is
Hello Dimitri,
Cool, thank you.
Even though.. it looks a little... ehm... well optimized? Or shall I say
hard to read? However, it should work for what I want.
Shouldn't such a thing be at least in contrib? How about the reverse,
filling a large object with a bytea value? Admittedly, this is
Hi,
Le mardi 14 novembre 2006 14:36, Markus Schiltknecht a écrit :
> I want to convert some large objects to bytea fields on the server.
> Searching through the documentation didn't reveal any hints. Am I
> missing something or is there really no such thing as a
> lo_convert_to_bytea function?
Yo
Hi,
I want to convert some large objects to bytea fields on the server.
Searching through the documentation didn't reveal any hints. Am I
missing something or is there really no such thing as a
lo_convert_to_bytea function?
Regards
Markus
---(end of broadcast)--
