[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] Problems renaming org units in relation to clin.test_
From: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-devel] Problems renaming org units in relation to clin.test_org |
Date: |
Thu, 11 Jul 2013 22:04:51 +0200 |
User-agent: |
Mutt/1.5.21 (2010-09-15) |
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