[Pkg-dspam-misc] dspam 3.9 database upgrade : fix for the postgesql backend.

[Julien Valroff]

Hi Philippe and others,

Le samedi 27 mars 2010 à 14:06 +0100, Philippe Le Brouster a écrit :
> Hi,
> 
> I'm currently doing some tests with the dspam package 3.9 (from
> kirya/Lenny), particularly an upgrade from the package dspam 3.6.8
> (from Debian/Lenny) with the postgresql backend.
> 
> It seems that the SQL schema update from 3.8 to 3.9 for the postgresql
> backend is missing.

The only thing I can see in the UPGRADING file is the following
statement:
2. Ensure PosgreSQL is using the new database schema. The following clauses should
   be executed for upgrading pre-3.9.0 DSPAM PosgreSQL schema to the 3.9.0 schema:
     ALTER TABLE dspam_preferences ALTER COLUMN uid TYPE integer;
     ALTER TABLE dspam_signature_data ALTER COLUMN uid TYPE integer;
     ALTER TABLE dspam_stats ALTER COLUMN uid TYPE integer;
     ALTER TABLE dspam_token_data ALTER COLUMN uid TYPE integer;
     DROP INDEX IF EXISTS id_token_data_sumhits;

   If you are using virtual users in DSPAM, then you should execute the following
   clause for upgrading pre-3.9.0 DSPAM virtual uids to the 3.9.0 schema:
     ALTER TABLE dspam_virtual_uids ALTER COLUMN uid TYPE integer;

It is already present in debian/sqlfiles/upgrade/pgsql/3.8
This file should actually be renamed to 3.9 - I had added it before the
official 3.9.0 release - but this should not cause any issue anyway, as
the dbconfig-commong documentation states:
"when a package upgrade occurs, all instances of VERSION which are newer
than the previously installed version will be applied, in order"

Would you please explain what your patch makes, and where have you seen
that it is necessary to be run?
Sorry if that might seem idiot questions, but I must say I haven't
worked on this for a quite long time now, and I am not a pgsql person ;)

I also take the leave to re-raise a ***CALL FOR HELP*** as it seems I am
the only one to work on trying to get DSPAM packages for Debian, but I
do not have all the required skills to achieve this alone.

Cheers,
Julien