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

[Vincent Bernat]

OoO  En  ce début  de  soirée  du lundi  02  janvier  2012, vers  21:26,
Hanspeter Kunz <hkunz at ifi.uzh.ch> disait :

> 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

Thanks  for  the  report! I  have  fixed  in  0.7-3  which I  have  just
uploaded. Unfortunately, you will have  to fix your installation by hand
by playing rules thos rules by hand:
 /usr/share/dbconfig-common/data/roundcube/upgrade/pgsql/0.7-1

From "DROP SEQUENCE messages_ids;" to the end.
-- 
Vincent Bernat ☯ http://vincent.bernat.im

Choose variable names that won't be confused.
            - The Elements of Programming Style (Kernighan & Plauger)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-roundcube-maintainers/attachments/20120102/c7bdd55e/attachment-0001.pgp>