[Top][All Lists]

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

Re: [Gnumed-devel] limbo table entries

From: Horst Herb
Subject: Re: [Gnumed-devel] limbo table entries
Date: Sun, 19 Jan 2003 23:43:00 +1100
User-agent: KMail/1.4.3

On Sun, 19 Jan 2003 20:52, Horst Herb wrote:
> Doesn't require much work either: all I have to do is modify the "audit
> trail" trigger generator script a little, and have the limbo table created.
> Since the limbo flag would be inherited via the "audit" parent, no changes
> need to be made to existing table design either (unless the tables already
> contain data)

One more case needs to be taken care of: if anybody but the creator of the 
record attempts to modify the record while in limbo, the ON UPDATE trigger 
needs to clear the limbo flag and audit the manipulation too.


reply via email to

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