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

[Busser, Jim]

So here is what, hopefully understandably, is really bothering me …

If in

        clin.clin_root_item

my last 5 rows (ordered by pk_item) end with pk_item numbers as follows:

        gnumed_v18=> SELECT pk_item
                FROM clin.clin_root_item
                ORDER BY pk_item
                OFFSET (SELECT COUNT(pk_item)
                                        FROM clin.clin_root_item)-5 ;

         pk_item
         ---------
         1066
         1067
         1068
         1069
         1071
         (5 rows) 

AND If rows in the clin.clin_root_item table are not supposed to be able to be 
deleted (except this possibility is hinted at by the missing 1070), why does my 
table

        gnumed_v18=> SELECT COUNT(pk_item)
                                        FROM clin.clin_root_item ;
         count
         -------
         1031
         (1 row)

contain only 1031 rows? What happened to the other roughly 40 rows? 

-- Jim