Re: [Gnumed-devel] limbo table entries

[Horst Herb]

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.

Horst