Hello!
In process of db upgrade I'm getting such errors:
..
UPDATE 0
ERROR: null value in column "discovery_groupid" violates not-null constraint
UPDATE 0
UPDATE 1
UPDATE 0
ALTER TABLE
ERROR: insert or update on table "config" violates foreign key constraint "c_config_2"
DETAIL: Key (discovery_groupid)=(0) is not present in table "groups".
ALTER TABLE
..
It is safe to use db upgraded such way?
On this test server we have pgsql 8.4.6, but in case, this is important, it is possible to test this on 9.x
In process of db upgrade I'm getting such errors:
..
UPDATE 0
ERROR: null value in column "discovery_groupid" violates not-null constraint
UPDATE 0
UPDATE 1
UPDATE 0
ALTER TABLE
ERROR: insert or update on table "config" violates foreign key constraint "c_config_2"
DETAIL: Key (discovery_groupid)=(0) is not present in table "groups".
ALTER TABLE
..
It is safe to use db upgraded such way?
On this test server we have pgsql 8.4.6, but in case, this is important, it is possible to test this on 9.x
Comment