http://issues.apache.org/SpamAssassin/show_bug.cgi?id=4653
Summary: bayes_pg.sql -- syntax error
Product: Spamassassin
Version: 3.1.0
Platform: Other
OS/Version: FreeBSD
Status: NEW
Severity: major
Priority: P3
Component: spamassassin
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
After configuring PostgreSQL 7.4.9, FreeBSD 5.4-STABLE as per the README.bayes
(including adding the plpgsql language) attempting to use the SQL in
bayes_pg.sql resulted in the following error.
psql:bayes_pg.sql:114: ERROR: syntax error at or near "INTEGER" at character 48
While far from a PostgreSQL expert, my poking around at least has the following
patch allowing the (modified) bayes_pg.sql to execute. I have not yet been able
to switch over to PostgreSQL, though I appear to have other configuration
issues.
63,67c63,67
< CREATE OR REPLACE FUNCTION put_tokens(inuserid INTEGER,
< intokenary BYTEA[],
< inspam_count INTEGER,
< inham_count INTEGER,
< inatime INTEGER)
---
> CREATE OR REPLACE FUNCTION put_tokens(INTEGER,
> BYTEA[],
> INTEGER,
> INTEGER,
> INTEGER)
69a70,74
> inuserid ALIAS FOR $1;
> intokenarray ALIAS FOR $2;
> inspam_count ALIAS FOR $3;
> inham_count ALIAS FOR $4;
> inatime ALIAS FOR $5;
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
