gnumed-bugs
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Gnumed-bugs] gm-remove_person.sh needs updating?


From: Jim Busser
Subject: [Gnumed-bugs] gm-remove_person.sh needs updating?
Date: Wed, 16 Feb 2011 00:00:25 -0800

Tried deleting Kirk:



MacBook:external-tools djb$ export PATH=/opt/local/lib/postgresql84/bin:$PATH
MacBook:external-tools djb$ ./gm-remove_person.sh gnumed_v14 12

Creating removal script ...
    /tmp/gm-remove_person.sql

Are you sure you want to remove the person #12
*irrevocably* from the database "gnumed_v14" ?

Remove ? [yes / NO]:yes

Removing person #12 from database "gnumed_v14" ...
Password for user gm-dbo: 
ERROR: failed to remove person.
       see: gm-remove_person.log


log contents below ******
***********************************
SET
BEGIN
DELETE 1
psql:/tmp/gm-remove_person.sql:18: ERROR:  update or delete on table "episode" 
violates foreign key constraint "clin_hx_family_fk_episode_fkey" on table 
"clin_hx_family"
DETAIL:  Key (pk)=(1) is still referenced from table "clin_hx_family".


-- Jim




reply via email to

[Prev in Thread] Current Thread [Next in Thread]