Re: [Gnumed-devel] Inadvertent deletion of Procedure when Deleting episode

[Karsten Hilbert]

On Thu, Aug 01, 2013 at 08:43:53AM +0000, Jim Busser wrote:

> >> It appears that the procedure was not deleted, since I can still find it 
> >> at the bottom of
> >> 
> >>    select * from clin.procedure ;
> >> 
> >> but the problem now is that the episode to which it is keyed
> >> 
> >>    fk_episode = 397
> >> 
> >>    select pk from clin.episode WHERE pk = 397 ;

>       gnumed_v18=> select modified_when,
>               pk_item, clin_when, fk_encounter, fk_episode
>               FROM clin.clin_root_item
>               WHERE fk_episode = 397

> The orphaned procedure, which has a fk_episode of 377

Typo ?

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