Package: libdspam7-drv-pgsql Version: 3.6.4-4 Severity: important The PG driver for dspam supports bigint for the token field and numeric(10). bigint is prefered, but if moving from hash to sql the value is too large to fit into a bigint and so the workaround is to use numeric(10) instead. (there is a program to dump a numeric(10) version to a bigint version, but that segfaults -- another bug for that when I have the data I need).
Anyway, the token data in improperly quoted. Patch below: --- pgsql_drv.c.orig 2006-05-27 20:15:38.309621367 -0400 +++ pgsql_drv.c 2006-05-27 20:03:20.597998961 -0400 @@ -2620,7 +2620,7 @@ if (type == 1) { snprintf(buffer, bufsz, "%lld", token); } else { - snprintf(buffer, bufsz, "'%llu'", token); + snprintf(buffer, bufsz, "%llu", token); } return buffer; } -- System Information: Debian Release: testing/unstable APT prefers unstable APT policy: (500, 'unstable') Architecture: i386 (i686) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.16.13-xenU Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) Versions of packages libdspam7-drv-pgsql depends on: ii dbconfig-common 1.8.13 common framework for packaging dat ii debconf [debconf-2.0] 1.5.1 Debian configuration management sy ii libc6 2.3.6-9 GNU C Library: Shared libraries ii libdspam7 3.6.4-4 DSPAM is a scalable and statistica ii libldap2 2.1.30-13 OpenLDAP libraries ii libpq4 8.1.4-1 PostgreSQL C client library ii postgresql-client-8.1 8.1.4-1 front-end programs for PostgreSQL ii ucf 2.0010 Update Configuration File: preserv Versions of packages libdspam7-drv-pgsql recommends: ii postgresql-8.1 8.1.4-1 object-relational SQL database, ve -- debconf information: libdspam7-drv-pgsql/pgsql/method: unix socket libdspam7-drv-pgsql/remote/host: libdspam7-drv-pgsql/pgsql/manualconf: libdspam7-drv-pgsql/pgsql/authmethod-admin: ident libdspam7-drv-pgsql/db/dbname: libdspam7-drv-pgsql/pgsql/changeconf: false libdspam7-drv-pgsql/install-error: abort libdspam7-drv-pgsql/import-oldsettings: libdspam7-drv-pgsql/internal/reconfiguring: false libdspam7-drv-pgsql/pgsql/authmethod-user: ident libdspam7-drv-pgsql/database-type: pgsql libdspam7-drv-pgsql/performing_upgrade: true libdspam7-drv-pgsql/remove-error: abort libdspam7-drv-pgsql/remote/newhost: libdspam7-drv-pgsql/db/app-user: libdspam7-drv-pgsql/purge: false libdspam7-drv-pgsql/dbconfig-remove: true * libdspam7-drv-pgsql/dbconfig-install: false libdspam7-drv-pgsql/dbconfig-upgrade: true libdspam7-drv-pgsql/pgsql/admin-user: postgres libdspam7-drv-pgsql/pgsql/no-empty-passwords: libdspam7-drv-pgsql/upgrade-backup: true libdspam7-drv-pgsql/upgrade-error: abort libdspam7-drv-pgsql/remote/port: libdspam7-drv-pgsql/passwords-do-not-match: !DSPAM:4478ebf433731223273615! -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]