[Pkg-nagios-devel] Bug#774917: Bug#774917: icinga-idoutils: fails to upgrade squeeze -> wheezy -> jessie: ERROR: syntax error at or near "EXISTS" LINE 1: ALTER TABLE icinga_comments DROP CONSTRAINT IF EXISTS uq_com... ^

[Alexander Wirt]

On Sat, 10 Jan 2015, Andrey Rahmatullin wrote:

> On Fri, Jan 09, 2015 at 03:39:51AM +0100, Andreas Beckmann wrote:
> >   error encountered processing /usr/share/dbconfig-common/data/icinga-idoutils/upgrade/pgsql/1.10.1-1:
> >   ERROR: syntax error at or near "EXISTS" LINE 1: ALTER TABLE icinga_comments DROP CONSTRAINT IF EXISTS uq_com... ^
> DROP CONSTRAINT IF EXISTS was added in PostgreSQL 9.0, which version is
> used on the machine?
probably the 8.4 from squeeze. The package doesn't support a direct update
from squeeze without updating the postgresql version. 

And tbh I don't think we should support that. We shouldn't expect outdated
database versions.

Any other oppinions? 

Alex

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 819 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-nagios-devel/attachments/20150110/ea6b6dd9/attachment.sig>