[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-bugs] GNUmed 1.5.0 - needs one more fixup relating to test o
From: |
Busser, Jim |
Subject: |
Re: [Gnumed-bugs] GNUmed 1.5.0 - needs one more fixup relating to test orgs? |
Date: |
Thu, 15 Jan 2015 20:21:33 +0000 |
On 2015-01-15, at 9:52 AM, "Busser, Jim" <address@hidden> wrote:
> By running, from server 20.1 bootstrap, both
>
> ./fixup-db.sh 19
> ./upgrade-db.sh 19 20
>
> I seem to have gotten past the schema requirements, except it seems my
> database contains data that violates a constraint that v20 would like to
> apply, and preventing me from completing the upgrade. The problem is:
>
> insert or update on table "test_org" violates foreign key constraint
> "test_org_fk_org_unit_fkey"DETAIL: Key (fk_org_unit)=(1) is not present in
> table "org_unit".
>
> Log attached.
>
> -- Jim
>
> <update_db-v19_v20.log>
Currently if I do
gnumed_v19=> SELECT pk, fk_org_unit, comment FROM clin.test_org ;
I get
pk | fk_org_unit | comment
----+-------------+------------------------------------------
1 | 10345 | self-measurement as reported by patient
2 | 10343 | any external organization, regardless + | | of real
source for measurements
11 | 21825 |
(3 rows)
and if I do
gnumed_v19=> SELECT pk, description FROM dem.org_unit where pk=10345 or
pk=10343 or pk=21825 ;
I get
pk | description -------+----------------
10343 | external org
10345 | patient
21825 | unassigned lab
(3 rows)
-- Jim