I haven't seen this mentioned yet, so if this is already being discussed I apologize.
As of Pg version 8.3, "Non-character data types are no longer automatically cast to TEXT". See http://www.postgresql.org/docs/8.3/static/release-8-3.html under section E.8.2.1. General This requires changes to the queries that are in amavisd-new by default. I have only been playing with amavisd for a few days, but I am familiar with this issue and will post modified queries as I get to them today (once I get into work). The result is that I got these messages in my log when I attempted to use SQL: Jul 6 22:38:18 gimli amavis[91931]: (91931-01) (!)lookup_sql: sql exec: err=7, 42883, DBD::Pg::st execute failed: ERROR: operator does not exist: bytea = character varying\nLINE 1: ...cy ON users.policy_id=policy.id WHERE users.email IN ($1,$2,...\n ^\nHINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. at (eval 115) line 166, <GEN14> line 5., 7, ERROR: operator does not exist: bytea = character varying\nLINE 1: ...cy ON users.policy_id=policy.id WHERE users.email IN ($1,$2,...\n ^\nHINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. Jul 6 22:38:18 gimli amavis[91931]: (91931-01) (!!)TROUBLE in process_request: sql exec: err=7, 42883, DBD::Pg::st execute failed: ERROR: operator does not exist: bytea = character varying\nLINE 1: ...cy ON users.policy_id=policy.id WHERE users.email IN ($1,$2,...\n ^\nHINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. at (eval 115) line 166, <GEN14> line 5. at (eval 116) line 280, <GEN14> line 5. Jul 6 22:38:18 gimli amavis[91931]: (91931-01) (!)Requesting process rundown after fatal error --TimH ------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/blackberry _______________________________________________ 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/
