OK, that makes good sense, but the default query doesn't . . . . . nevermind.
I opened amavisd and consequently added
$sql_allow_8bit_address = 1;
to amavisd.conf and it's happy now.
Not sure if that is what I'm sticking with, but it does fix the problem.
The database is a Postgres UTF8, and forgive my ignorance here, but will that
cover any kind of email address with a VarChar column type, or is there still a
need for VarBinary? I'm assuming that by using VarBinary I'll be losing the
capability to do string-based queries with wildcards such as "LIKE
'%domain.com'. Is that correct also?
--- On Thu, 6/11/09, Mark Martinec <mark.martinec+ama...@ijs.si> wrote:
> From: Mark Martinec <mark.martinec+ama...@ijs.si>
> Subject: Re: [AMaViS-user] 2.6.3 with Postgres causing "ERROR: operator does
> not exist: bytea = character varying"
> To: amavis-user@lists.sourceforge.net
> Date: Thursday, June 11, 2009, 5:23 AM
> Brian,
>
> > HEY, it's the email column
>
> Ah, ok, that makes more sense.
>
> > which is bytea --- on my other amavis server
> > it's character varying 255 . . . . why the change?
>
> Because in principle an envelope e-mail address can happen
> to
> contain any junk, an if there are any 8-bit characters
> there,
> there is no guarantee it will be valid string according to
> a character set
> chosen for an SQL field. So it's prudent not to require an
> e-mail address
> to be in any particular character set, but declare it as a
> string of octets.
>
> See release notes (2.6.0), search for:
>
> - when SQL logging (pen pals) or SQL lookups are used, one
> can choose a
> binary or a character data type for fields
> users.email, mailaddr.email,
> and maddr.email; now may be a good opportunity to
> change a data type
> to binary (string of arbitrary bytes, no character
> set associated).
> Background: ...
>
>
> 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/
>
------------------------------------------------------------------------------
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/
