Bug Tracker item #3413998, was opened at 2011-09-26 13:53 Message generated for change (Settings changed) made by sbajic You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=3413998&group_id=250683
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: v3.10.x >Status: Pending Resolution: None Priority: 5 Private: No Submitted By: Ingo Theiss (itheiss) Assigned to: Stevan Bajic (sbajic) Summary: DSPAM broken after upgrade to PostgreSQL 9.1 Initial Comment: After PostgreSQL 9.1 has hit Debian/testing DSPAM fails to insert data into the table 'dspam_signature_data' (see attached sql_erros.txt). After digging around in the source code I have seen the function 'PQescapeByteaConn' (pgsql_drv.c line 1574) is used to escape the data. Unfortunately with PostgreSQL 9.1 the default from the setting 'standard_conforming_strings' has changed from 'off' to 'on'. Please read the following thread as I am not an expert in C-Programming nor in PostgreSQL: http://postgresql.1045698.n5.nabble.com/PQescapeByteaConn-returns-wrong-string-for-PG9-1-Beta3-td4667713.html I can confirm that DSPAM is working again if I set 'standard_conforming_strings = off' in my postgresql.conf. But since the new default for PostgreSQL 9.1 is 'standard_conforming_strings = on' this should be considered in pgsql_drv.c. ---------------------------------------------------------------------- Comment By: Ingo Theiss (itheiss) Date: 2011-10-03 10:55 Message: Hi Stevan, so far I have used the Debian packages from Julien Valroff (http://www.kirya.net/) which are available from the official Debian Backports repository. I will try to compile the pgsql part and the if problem still exists. Regards, Ingo ---------------------------------------------------------------------- Comment By: Stevan Bajic (sbajic) Date: 2011-10-01 11:37 Message: Hello Ingo, can you try latest GIT version of DSPAM and tell me if the problem still exists there? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=3413998&group_id=250683 ------------------------------------------------------------------------------ RSA® Conference 2012 Save $700 by Nov 18 Register now! http://p.sf.net/sfu/rsa-sfdev2dev1 _______________________________________________ Dspam-devel mailing list Dspam-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-devel