Re: [Gnumed-bugs] GNUmed 1.5.0 - needs one more fixup relating to test orgs?

[Busser, Jim]

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