Re: [Gnumed-devel] Problems renaming org units in relation to clin.test_org

[Karsten Hilbert]

On Wed, Jul 10, 2013 at 12:34:03AM +0000, Jim Busser wrote:

> 2. Also, the org_unit button 'Remove' seems not to work
> because despite that it seems invokable (clickable)

Ah, niiice. What a bug. Fixed.

> the button will not remove these suborgs. It seems not to be any issue of 
> foreign key constraints because I can, in psql, do
> 
> DELETE FROM dem.org<http://dem.org>_unit WHERE pk = 21813
> DELETE FROM dem.org<http://dem.org>_unit WHERE fk_org = 24706
> 
> after which I can do
> 
> DELETE FROM dem.org<http://dem.org> org WHERE org.pk=24705
> DELETE FROM dem.org<http://dem.org> org WHERE org.pk=24706
> -- Jim

I access pk_org rather than pk_org_unit when indexing the
org_unit, which doesn't fail, because pk_org exists in
org_units, but is the wrong key ;-)

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