[Libpqxx-general] Exec query with binary parameters

[Michael Akinde]

No interest in this question? It would be nice to know if this is worth 
doing, before we spend a bunch of time trying to implement this.

Regards,

Michael A.
WDB / wdb.met.no

Michael Akinde wrote:
> 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 
> _______________________________________________
> Libpqxx-general mailing list
> Libpqxx-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/libpqxx-general
>   

-------------- 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/20090323/a2a031a8/attachment.vcf