Brian, > There's a good chance that I've misconfigured something, but I'm at a loss > for direction.
> amavis[6032]: (06032-01) (!)lookup_sql: sql exec: err=7, 25P01, DBD::Pg::st > execute failed: ERROR: operator does not exist: bytea = character > varying\nLINE 1: ...HERE (users.policy_id=policy.id) AND (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 97) line 166, <GEN13> line > 5., 7, ERROR: operator does not exist: bytea = character varying\nLINE 1: > ...HERE (users.policy_id=policy.id) AND (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. Seems your field users.policy_id is of type 'bytea', while policy.id is 'character varying'. They should be of the same data type. It would be more common to let both be integers, but string is probably alright too, as long as both are of the same type. Mark ------------------------------------------------------------------------------ Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects _______________________________________________ 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/
