Re: [Gnumed-bugs] a query problem when bootstrapping bundle [v18-v19-dynamic]

[Karsten Hilbert]

On Sun, Nov 17, 2013 at 08:53:38PM +0000, Jim Busser wrote:

> On closer examination I had misjudged the purpose of the problem query from 
> the log which was
> 
> insert into dem.org<http://dem.org>_unit (fk_org, description)
> select
> (select pk from dem.org<http://dem.org> where dem.org.description = 
> c_hs.narrative),
> 'unit of ' || c_hs.narrative
> from
> clin.hospital_stay c_hs
> where
> not exists (
> select 1 from dem.org<http://dem.org>_unit
> where
> dem.org<http://dem.org>_unit.description = 'unit of ' || c_hs.narrative
> and
> fk_org = (select pk from dem.org<http://dem.org> where dem.org.description = 
> c_hs.narrative)
> )

I have pushed to the git tree various patches regarding this
and a few other problems with bootstrapping.

I encourage people to test and report their mileage.

Based on that I'll release 1.4.1 / 19.1 this week.

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