You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@spamassassin.apache.org by Amos <a....@gmail.com> on 2005/12/08 23:43:20 UTC

SA 3.1.0, PostgreSQL 8.1.0, DBI 1.49, DBD::Pg 1.43

When I attempt to sa-learn a backup from another system running 3.0.4
with DB_File for the Bayes DB, I get these:

[5799] dbg: bayes: tok_get: SQL error: ERROR:  invalid input syntax
for type bytea
[5799] dbg: bayes: _put_token: SQL error: ERROR:  invalid input syntax
for type bytea
[5799] dbg: bayes: error inserting token for line: t_3_23_1134072161_5c96df5ba0
[5799] dbg: bayes: tok_get: SQL error: ERROR:  invalid input syntax
for type bytea
[5799] dbg: bayes: _put_token: SQL error: ERROR:  invalid input syntax
for type bytea

Looks like this may be related to this:

http://thread.gmane.org/gmane.mail.spam.spamassassin.general/73358

http://issues.apache.org/SpamAssassin/show_bug.cgi?id=4640

Bummer. Has anybody tried DBD-Pg-1.43_1?

Re: SA 3.1.0, PostgreSQL 8.1.0, DBI 1.49, DBD::Pg 1.43

Posted by Amos <a....@gmail.com>.

Have folks gotten things to work with previous versions of Postgres
and/or DBD-Pg? Since time is tight to fiddle with this box, looks like
I'll just continue using DB_File for now.


On 12/8/05, Amos <a....@gmail.com> wrote:
> When I attempt to sa-learn a backup from another system running 3.0.4
> with DB_File for the Bayes DB, I get these:
>
> [5799] dbg: bayes: tok_get: SQL error: ERROR:  invalid input syntax
> for type bytea
> [5799] dbg: bayes: _put_token: SQL error: ERROR:  invalid input syntax
> for type bytea
> [5799] dbg: bayes: error inserting token for line: t_3_23_1134072161_5c96df5ba0
> [5799] dbg: bayes: tok_get: SQL error: ERROR:  invalid input syntax
> for type bytea
> [5799] dbg: bayes: _put_token: SQL error: ERROR:  invalid input syntax
> for type bytea
>
> Looks like this may be related to this:
>
> http://thread.gmane.org/gmane.mail.spam.spamassassin.general/73358
>
> http://issues.apache.org/SpamAssassin/show_bug.cgi?id=4640
>
> Bummer. Has anybody tried DBD-Pg-1.43_1?
>