Re: [Gnumed-devel] backend notification

[Karsten Hilbert]

> I thought about adding the patient ID to the notify name
> before. I think I stumbled when I couldn't think of how to
> actually get at the relevant patient ID unambigously. Your
> suggestion makes me think again. One problem is, though, that
> PostgreSQL currently does not do per-row triggers so a trigger
> on UPDATE will fire once for all rows (e.g. patients)
I was wrong here. It's the other way round. I am currently
adding some triggers to test the concept. It is going to work
for at least those tables that are children of clin_root_item
(since they allow us to backtrack to the patient ID). 

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