[Libpqxx-general] Exec query with binary parameters

[Michael Akinde]

Hi,

In our project, we use pqxx to insert large binary objects into a 
postgres database. Recently, we've moved from large objects to bytea 
objects in the database, but have hit upon a complication. Inserting 
very large binary objects apparently forces us to convert the binary 
data to text in order to use T.exec().

libpq, of course, has the PQExecParam function which allows to pass 
variables as binary objects.

Pqxx does not include this functionality, as far as I can see. Or have I 
missed something?

Looking at the implementation of T.exec, it seems that it would be easy 
to include a similar function ( T.execParam ? ) that maps to PQExecParam 
instead of PQExec. Is there anything that would complicate that?

Regards,

Michael A.
WDB / wdb.met.no  
-------------- next part --------------
A non-text attachment was scrubbed...
Name: michael.akinde.vcf
Type: text/x-vcard
Size: 287 bytes
Desc: not available
Url : http://pgfoundry.org/pipermail/libpqxx-general/attachments/20090312/03f060d7/attachment.vcf