[Pkg-roundcube-maintainers] Bug#654297: roundcube-pgsql: db update 0.6+dfsg-1 -> 0.7-1 fails

[Hanspeter Kunz]

Package: roundcube
Version: 0.6+dfsg-1
Severity: normal

Hi,

upgrading the postgres db from 0.6+dfsg-1 -> 0.7-1 fails with:

creating database backup
in /var/cache/dbconfig-common/backups/roundcube_0.6+dfsg-1.pgsql.
applying upgrade sql for 0.6+dfsg-1 -> 0.7-1.
error encountered
processing /usr/share/dbconfig-common/data/roundcube/upgrade/pgsql/0.7-1:
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"dictionary_user_id_language_key" for table "dictionary" NOTICE: CREATE
TABLE / PRIMARY KEY will create implicit index "searches_pkey" for table
"searches" NOTICE: CREATE TABLE / UNIQUE will create implicit index
"searches_user_id_key" for table "searches" ERROR: sequence
"messages_ids" does not exist

cheers,
Hp

-- System Information:
Debian Release: 6.0.3
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 2.6.32-5-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages roundcube-pgsql depends on:
ii  php-mdb2-driver-pgsql 1.5.0b2-1          PHP PEAR module to provide a Postg
ii  postgresql-client-8.4 8.4.9-0squeeze1+b1 front-end programs for PostgreSQL

roundcube-pgsql recommends no packages.

Versions of packages roundcube-pgsql suggests:
pn  postgresql-server             <none>     (no description available)

Versions of packages roundcube-core depends on:
ii  apache2                2.2.16-6+squeeze4 Apache HTTP Server metapackage
ii  apache2-mpm-prefork [h 2.2.16-6+squeeze4 Apache HTTP Server - traditional n
ii  dbconfig-common        1.8.46+squeeze.0  common framework for packaging dat
ii  debconf [debconf-2.0]  1.5.36.1          Debian configuration management sy
ii  libjs-jquery           1.7-1             JavaScript library for dynamic web
ii  libmagic1              5.04-5            File type determination library us
ii  php-auth               1.6.2-1           PHP PEAR modules for creating an a
ii  php-mail-mime          1.8.0-2           PHP PEAR module for creating MIME
ii  php-mdb2               2.5.0b2-1         PHP PEAR module to provide a commo
ii  php-net-smtp           1.4.2-3           PHP PEAR module implementing SMTP
ii  php-net-socket         1.0.9-2           PHP PEAR Network Socket Interface
ii  php5                   5.3.3-7+squeeze3  server-side, HTML-embedded scripti
ii  php5-gd                5.3.3-7+squeeze3  GD module for php5
ii  php5-intl              5.3.3-7+squeeze3  internationalisation module for ph
ii  php5-mcrypt            5.3.3-7+squeeze3  MCrypt module for php5
ii  php5-pspell            5.3.3-7+squeeze3  pspell module for php5
ii  tinymce                3.3.8+dfsg0-0.1   platform independent web based Jav
ii  ucf                    3.0025+nmu1       Update Configuration File: preserv

Versions of packages roundcube depends on:
ii  roundcube-core                0.6+dfsg-1 skinnable AJAX based webmail solut

-- debconf information:
  roundcube/upgrade-error: abort
  roundcube/pgsql/authmethod-user: password
  roundcube/purge: false
* roundcube/dbconfig-install: true
  roundcube/db/dbname: roundcube
  roundcube/language: en_US
  roundcube/remote/newhost:
  roundcube/pgsql/changeconf: false
  roundcube/upgrade-backup: true
  roundcube/install-error: abort
  roundcube/mysql/admin-user: root
  roundcube/hosts:
  roundcube/pgsql/authmethod-admin: ident
  roundcube/dbconfig-remove:
  roundcube/pgsql/admin-user: postgres
  roundcube/internal/skip-preseed: false
  roundcube/db/app-user: roundcube
  roundcube/dbconfig-reinstall: false
  roundcube/mysql/method: unix socket
  roundcube/remove-error: abort
  roundcube/restart-webserver: true
  roundcube/dbconfig-upgrade: true
  roundcube/remote/port:
  roundcube/pgsql/method: unix socket
  roundcube/pgsql/manualconf:
  roundcube/db/basepath:
  roundcube/pgsql/no-empty-passwords:
  roundcube/passwords-do-not-match:
  roundcube/internal/reconfiguring: false
  roundcube/reconfigure-webserver: apache2, lighttpd
* roundcube/database-type: pgsql
  roundcube/remote/host:
  roundcube/missing-db-package-error: abort