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

[Busser, Jim]

On 2013-08-01, at 2:19 AM, Karsten Hilbert <address@hidden>  wrote:

> 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 ?

Yes, sorry, in my errant clarification "The orphaned procedure …" whose 
fk_episode I meant to say ought to have been 397

-- JIm