Re: postgres database

2006-11-25 Thread Chris Purves
Tom Allison wrote: To set up SQL for Bayes look at: /usr/share/doc/spamassassin/sql or http://wiki.apache.org/spamassassin/BetterDocumentation/SqlReadmeBayes To set site-wide bayes with sql, either: 1. Always call spamc or spamassassin with the same user 2. set 'bayes_sql_override_username'

Re: postgres database

2006-11-24 Thread Chris Purves
Tom Allison wrote: Rick Macdougall wrote: Tom Allison wrote: I was reading through the man pages about the use of a database for the storage of bayesian tokens. Is this a list that is global to the mail server, or something that is distinct for each user of that mail server? In other words

Re: postgres database

2006-11-24 Thread Tom Allison
Rick Macdougall wrote: Tom Allison wrote: I was reading through the man pages about the use of a database for the storage of bayesian tokens. Is this a list that is global to the mail server, or something that is distinct for each user of that mail server? In other words -- will I have the

Re: postgres database

2006-11-24 Thread Rick Macdougall
Tom Allison wrote: I was reading through the man pages about the use of a database for the storage of bayesian tokens. Is this a list that is global to the mail server, or something that is distinct for each user of that mail server? In other words -- will I have the exact same bayesian hist

postgres database

2006-11-24 Thread Tom Allison
I was reading through the man pages about the use of a database for the storage of bayesian tokens. Is this a list that is global to the mail server, or something that is distinct for each user of that mail server? In other words -- will I have the exact same bayesian history in my token lib

Re: errors in postgres database queries

2006-03-28 Thread Ingo Freund
Michael Parker wrote: > Ingo Freund wrote: > >>The system worked well with mySQL. > > > WARNING: Bayes SQL does indeed work best with MySQL. Feel free to > search the users/dev list in the past for more information. > > That might be, but where should be the need to let two different databas

Re: errors in postgres database queries

2006-03-27 Thread Ingo Freund
Michael Parker schrieb: > Ingo Freund wrote: > >>The system worked well with mySQL. > > > WARNING: Bayes SQL does indeed work best with MySQL. Feel free to > search the users/dev list in the past for more information. > > >>Yes I followed the instructions. >>Migrating to Postgres went through

Re: errors in postgres database queries

2006-03-27 Thread Michael Parker
Ingo Freund wrote: > > The system worked well with mySQL. WARNING: Bayes SQL does indeed work best with MySQL. Feel free to search the users/dev list in the past for more information. > Yes I followed the instructions. > Migrating to Postgres went through without any problems. > > This is what

Re: errors in postgres database queries

2006-03-27 Thread Ingo Freund
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:

Re: errors in postgres database queries

2006-03-27 Thread Michael Parker
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 giv

errors in postgres database queries

2006-03-27 Thread Ingo Freund
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 m