Hi
Currently for dbmail to work with postgresql >= 9.0 a workaround is
required:
(as per the INSTALL file) to modify postgresql.conf to change
bytea_output = 'hex' to bytea_output = 'escape'.
libzdb since version 2.11 supports the default 'hex' format, which means
no change to postgresql.conf is needed, if this version is used.
http://www.tildeslash.com/pipermail/libzdb-general/2012-December/000244.html
:
Version 2.11 of libzdb is now available:
Changes in this release:
------------------------
* New: Added support for the new bytea hex encoding format
introduced in PostgreSQL 9.0. This means that ResultSet_getBlob
will correctly return the binary stored in a bytea column independent
if the column is escape encoded (old format) or hex encoded (new format).
Changing bytea_output applies to all databases on a system, not just
dbmail, so it is not a very good solution.
Could a dependency be made to use libzdb >= 2.11?
I have not tried this, this is just a hypothetical.
Regards,
Joel van Velden
_______________________________________________
Dbmail-dev mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
