Subject | Re: Implementing dirty flag in a Firebird database |
---|---|
Author | Svein Erling Tysvær |
Post date | 2005-05-17T18:09:51Z |
--- In firebird-support@yahoogroups.com, Lester Caine wrote:
-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
> Add a few triggers?Except a few theoretical cases:
> 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 ;)
-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