gnumed-devel
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] layout managers


From: Karsten Hilbert
Subject: Re: [Gnumed-devel] layout managers
Date: Sun, 25 Jul 2004 16:03:12 +0200
User-agent: Mutt/1.3.22.1i

> > - table trigger sends NOTIFY with patient ID attached
> >   - no one emits NOTIFIES
> 
> The bit where this fails over is that NOTIFY cannot carry any parameters - at 
> least not tile version 7.3, and I doubt this has changed.
It doesn't fall over. It works now, today, in your very CVS
version of the code.

> Thus, the backend can send a NOTIFY that *a* patient has changed, but that 
> mechanism won't tell you which one.
Why of course it does. Think EXECUTE.

> Hence, you can either lock a particular row as soon as you intend to edit it 
> - 
> which will prevent anybody else to edit it at the same time - or it gets 
> very, very complicated.
Which is exactly what we do in all descendants of cClinItem.

> That is, you'll have to do a "select for update" statement whenever you 
> consider the ere *possibility* that a user interface element will change 
> data.
IOW always. And down the drain goes the idea of using readonly
connections.

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




reply via email to

[Prev in Thread] Current Thread [Next in Thread]