Subject Re: Implementing dirty flag in a Firebird database
Author Svein Erling Tysvær
--- In firebird-support@yahoogroups.com, Lester Caine wrote:
> Add a few triggers?
> Create a table with current and backup timestamp field, update the
> current field every time there is an insert or update ( via the
> triggers ) and check it against the last backup date before doing a
> backup - at which time you update both just before the backup.
> A bit cumbersome but it works ;)

Except a few theoretical cases:
-when daylight saving time ends in the autumn
-when the clock is changed for some other reason

An alternative would be to use a generator rather than a timestamp
field.

Set