--- In firebird-support@yahoogroups.com, "Simon Carter"
<simon.carter@t...> wrote:

> > Basic rule: Whenever you change a system setting, that might
> > interfer with some services, restart them!
>
> Agreed.
>
> > That would differ, if there was a case, where the timezone
> > changed automagically. But there isn't.
>
> There is, twice a year in the UK the clocks go forward/backwards

for BST, I

> think the next change is this weekend (or the following)
>
> Rgds
>
> Si Carter
> TECT Software Ltd
> http://www.tectsoft.net/

Hi Simon

Recently Auckland changed one hour to Daylight savings time and our
FB Engines, to the best of my knowledge, did not need a restart.
Perhaps it was restarted? I can't check a FB log as I deleted it last
week and the change was the first Sunday in October. I'd bet the
switch to Daylight Savings time was handled by the FB Engine, but I
am not 100% certain. Anyone reading this who has their FB log
available for reading over a Daylight Savings change care to inform
us?

So, if my guess is right, the FB engine handles a Daylight Savings
time change transparent to the user. But they are predictable.

Steffen, your comments:

1. You do not expect firebird to keep working, if you move the
database file to another directory, do you? (of course not)
2. You do not expect firebird to keep working, if you change the ip
of the system, do you? ("Yes" and this can happen each day for
clients, but "No" if your FB setup uses hard wired IP addresses)
3. You do not expect firebird to keep working, if you change the port
number in services, do you? (No, quite different)
4. Why do you expect firebird to keep working, if you change a system
setting such as timezone? (Well, the FB engine might already be doing
this for Daylight Savings changes - but this might not be a timezone
change. It might be quite reasonable that the FB Engine ignore TZ
changes, especially if you think of a TZ change as a physical
relocation.)

Basic rule: Whenever you change a system setting, that might interfer
with some services, restart them! (Is this too strong? - the time is
a basic setting and ... well, you know)
That would differ, if there was a case, where the timezone changed
automagically. But there isn't. That is the whole intention of my
original posting. (We guess the FB engine handles Daylight Savings
changes OK - but that might not be a TZ change. We also know the FB
Engine correctly reports system time after a change to the system
time. If we think of a TZ change requiring a time change could it be
that Windows is not reporting a TZ change as a time change?)

We are talking about a small likehood event. But is it took one line
of code to change in the FB Server and had neglibible impact on
performance I think it would be a worthwhile change.

Someone who knows the FB Engine and Win time API/services might
enlighten us.

Kind regards

Russell