You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@spamassassin.apache.org by Michael Parker <pa...@pobox.com> on 2004/12/10 16:18:39 UTC

BayesSQL PostgreSQL Support

Howdy,

As some of you may or may not know the support for PostgreSQL in the
BayesSQL storage engine was there but not really.  It works but it
doesn't really work well.

To help I've created a PostgreSQL specific module that has the
following properties:

1) Changed the token type column to bytea (necessary to handle the
   binary nature of the SHA1 hash).
2) Adjusted all of the SQL calls with token in them to properly
   typecast to the new bytea type.
3) The put_token logic has been moved into a PL/pgSQL procedure.
4) bayes_* tables are created WITHOUT OIDS
5) Some other things I've probably forgotten about.

You can find more informaiton in the bugzilla bug here:
http://bugzilla.spamassassin.org/show_bug.cgi?id=3771

Thanks to Stefan Kaltenbrunner and a couple of unnamed IRC folks for
their help in creating the patch.

Please feel free to try the new module and report any problems to
bugzilla.

Michael