PGSQL UPGRADE ERROR: Wrong relation name infrastructure

LATEST Official version.
Questions and discussions - NO ISSUES
FOR ISSUES => http://mantis.testlink.org

Moderators: Amaradana, TurboPT, TL Developers

Post Reply
jracione
TestLink user
Posts: 1
Joined: Tue Nov 30, 2010 2:57 pm

PGSQL UPGRADE ERROR: Wrong relation name infrastructure

Post by jracione »

file: /install/migration/migrate_18/migrate_18_to_19.php

Upgrade sql script for pgsql is wrong whe creating index inventory_idx1

It's:

CREATE INDEX /*prefix*/inventory_idx1 ON /*prefix*/infrastructure (testproject_id);
CREATE UNIQUE INDEX /*prefix*/inventory_uidx1 ON /*prefix*/infrastructure (name,testproject_id);

and the correct is:

CREATE INDEX /*prefix*/inventory_idx1 ON /*prefix*/inventory (testproject_id);
CREATE UNIQUE INDEX /*prefix*/inventory_uidx1 ON /*prefix*/inventory (name,testproject_id);
Post Reply