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

[Karsten Hilbert]

On Thu, Aug 01, 2013 at 11:55:18AM +0200, Karsten Hilbert wrote:

> In order for everyone to check the amount of dangling items
> I would suggest running the following queries:
> 
>       SELECT * from clin.v_pat_items c_vpi where not exists (
>               select 1 from clin.episode c_e where c_e.pk = c_vpi.fk_episode
>       );
> 
>       SELECT * from clin.v_pat_items c_vpi where not exists (
>               select 1 from clin.encounter c_e where c_e.pk = 
> c_vpi.fk_encounter
>       );

The above doesn't work (as v_pat_items *already* joins to
clin.episode -- never minding the fk_episode/encounter typo)
but this will:

        SELECT * from clin.clin_root_item c_vpi where not exists (
                select 1 from clin.episode c_e where c_e.pk = c_vpi.fk_episode
        );

        SELECT * from clin.clin_root_item c_vpi where not exists (
                select 1 from clin.encounter c_e where c_e.pk = 
c_vpi.fk_encounter
        );

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