[Top][All Lists]
[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
- [Gnumed-bugs] gm-remove_person.sh needs updating?,
Jim Busser <=