You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@spamassassin.apache.org by bu...@bugzilla.spamassassin.org on 2005/11/08 21:58:34 UTC
[Bug 4675] New: spamassassin: syntax error message from bayes_pg.sql
http://issues.apache.org/SpamAssassin/show_bug.cgi?id=4675
Summary: spamassassin: syntax error message from bayes_pg.sql
Product: Spamassassin
Version: unspecified
Platform: Other
URL: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=333979
OS/Version: other
Status: NEW
Severity: normal
Priority: P5
Component: Learner
AssignedTo: dev@spamassassin.apache.org
ReportedBy: spamassassin@packages.debian.org
I am trying to upgrade to spamassassin 3.1 and wanted to convert
our bayes database from the old Berkeley database to use
our Postgres installation that works for other packages. I
followed the bayes readme and the bayes.pg readme
and created a spamassassin postgres database to use.
I then tried
psql -U postgres -f bayes_pg.sql spamassassin and
partway through the program I get an error message.
Here is the total output from the program.
psql:bayes_pg.sql:13: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit
index "bayes_global_vars_pkey" for table "bayes_global_vars"
psql:bayes_pg.sql:22: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit
index "bayes_seen_pkey" for table "bayes_seen"
psql:bayes_pg.sql:31: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit
index "bayes_token_pkey" for table "bayes_token"
psql:bayes_pg.sql:47: NOTICE: CREATE TABLE will create implicit sequence
"bayes_vars_id_seq" for "serial" column "bayes_vars.id"
psql:bayes_pg.sql:47: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit
index "bayes_vars_pkey" for table "bayes_vars"
psql:bayes_pg.sql:112: ERROR: syntax error at or near "INTEGER" at character 48
THe error appears to come from the plpgsql procedure that is defined,
but I don't know enough about the language to see anything obvious.
I am running SA fine by still using our old BDB bayes database but it
would be great if I can get it transferred to our Postrgres.
-----
The reporter was using Postgres 7.4.7 -- it was suggested that Postgres 8.0 is
required. Is this correct? (If so, the docs need updating...)
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
[Bug 4675] spamassassin: syntax error message from bayes_pg.sql
Posted by bu...@bugzilla.spamassassin.org.
http://issues.apache.org/SpamAssassin/show_bug.cgi?id=4675
parkerm@pobox.com changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |DUPLICATE
------- Additional Comments From parkerm@pobox.com 2007-11-25 22:23 -------
Older versions of PostgreSQL do not like the named params. This has been fixed
in 3.3.0-dev. Please refer to bug 4653 if you would like to patch your older
version.
*** This bug has been marked as a duplicate of 4653 ***
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
[Bug 4675] spamassassin: syntax error message from bayes_pg.sql
Posted by bu...@bugzilla.spamassassin.org.
http://issues.apache.org/SpamAssassin/show_bug.cgi?id=4675
parkerm@pobox.com changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |parkerm@pobox.com
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.