Opened 10 years ago

Closed 10 years ago

Last modified 10 years ago

#508 closed defect (fixed)

PostgreSQL 8.4 does not work with pgsql_data_2.5.sql

Reported by: tbaschetti Owned by: dev
Priority: critical Milestone: 2.6 release
Component: database Version: 2.6 rc1
Keywords: PostgreSQL 8.4 Cc:

Description

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.

Change History (3)

comment:1 Changed 10 years ago by nimix

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

comment:2 Changed 10 years ago by tbaschetti

Resolution: fixed
Status: newclosed

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

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

comment:3 Changed 10 years ago by christoph

Note: See TracTickets for help on using tickets.