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

[Karsten Hilbert]

On Wed, Feb 16, 2011 at 12:00:25AM -0800, Jim Busser wrote:

> 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".

Improved in git master.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346