Michael Parker wrote: > Ingo Freund wrote: > >>Hi list, >> >>after my upgrade to spamassassin version 3.1.0 >>and migrate the database from mySQL to PostgreSQL there are >>coming up many errors in the postgres logfile all like this: >> >>ERROR: operator does not exist: character = bytea >>HINT: No operator matches the given name and argument type(s). You may need >>to add explicit type casts. >>ERROR: current transaction is aborted, commands ignored until end of >>transaction block >>ERROR: current transaction is aborted, commands ignored until end of >>transaction block >> > > > What are you using for bayes_store_module? Also, did you follow the > instructions in sql/README.bayes for installing all the proper pieces to > get Postgres up and running properly? > > Michael
The system worked well with mySQL. Yes I followed the instructions. Migrating to Postgres went through without any problems. This is what spamd uses: bayes_store_module Mail::SpamAssassin::BayesStore::PgSQL Ingo.
