Hi all, I'm setting up a mail server with Amavis for antispam and virus detection. For now, a lot of things work, but there seems to be some compatibility issues with postgresql > 8.3
Everytime queries are done with the db, I got these lines repeated infinitely in my postgre logs : 2009-11-16T15:15:54.514300+00:00 db postgres[41784]: [4-1] WARNING: 22P06: nonstandard use of \\ in a string literal at character 129 2009-11-16T15:15:54.514372+00:00 db postgres[41784]: [4-2] HINT: Use the escape string syntax for backslashes, e.g., E'\\'. 2009-11-16T15:15:54.514515+00:00 db postgres[41784]: [4-3] LOCATION: check_string_escape_warning, scan.l:1146 These seems to happen because with postgresql > 8.3, you have to use E'some\\text' and not 'some\\text' when using escape characters. Is this problem solved in a newer version (I run amavisd-new-2.6.4 (20090625) from the FreeBSD ports tree). Or is there any bugfixes ? Thanks, Julien Gormotte ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/