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

[Karsten Hilbert]

On Thu, Aug 01, 2013 at 01:04:55AM +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
> 
> no longer exists:
> 
>       select pk from clin.episode WHERE pk = 397 ;
>        pk
>       ----
>        (0 rows) 

I would suggest checking your database. It seems to be
lacking a foreign key from clin.clin_root_item.fk_episode to
clin.episode.pk.

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