PostgreSQL 8.4 does not work with pgsql_data_2.5.sql

[tbaschetti]

In PostgreSQL internal structure has changed, pg_catalog.pg_class does no longer contain reltriggers::smallint but has relhastrigger::boolean, so the import-script pgsql_data_2.5.sql fails at:

UPDATE pg_catalog.pg_class SET reltriggers = 0;

many subsequent inserts also fail as a consequence, resulting in an unusable database.

[nimix]

I think that should be done by ALTER TABLE ... DISABLE TRIGGER ALL; and ALTER TABLE ... ENABLE TRIGGER ALL;

[tbaschetti]

changed to ALTER TABLE ... DISABLE TRIGGER ALL; ALTER TABLE ... ENABLE TRIGGER ALL;

testet with PostgreSQL 8.1 to 8.4 (utf8 and iso), works

[christoph]

thanks for fixing, Thomas!

Here are the changesets

trunk

​http://trac.osgeo.org/mapbender/changeset/4532

2.6

​http://trac.osgeo.org/mapbender/changeset/4531