[Gnumed-devel] changes to add_name() in SQL

[Karsten Hilbert]

Syan,

your changes did seem to work but were just a workaround to
the broken trigger function f_uniq_active_name(). I disabled
the trigger altogether for now. The trigger function is what
we need to work on. It's intent is to be a before trigger that
sets all names for a given identity to inactive IF the
incoming update or insert is active. I am researching that but
cannot get it to work yet. I would have thought it works like
this:

if NEW.active = false then
    return NEW;
end if;
update
    names
set
    active = false
where
    id_identity = NEW.id_identity and
    active = true
;
return NEW;

For some reason this doesn't work.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346