Subject | Re: [firebird-support]Object in use? |
---|---|
Author | Adam |
Post date | 2006-02-01T10:44:17Z |
--- In firebird-support@yahoogroups.com, "Paul Hope" <paulhope@a...>
wrote:
in the past installing guardian against a classic install. The
guardian process was designed to watch the firebird server process and
restart it if it crashed. Of course if you use services, you could
always configure failure actions to restart the service.
But then again that wasn't your original question. You were enquiring
over whether anything had changed between IB and FB 1.5. The obvious
answer is yes. IB didn't even have classic on windows. From my
understanding, there should be no difference between the way FB 1.5 SS
and FB 1.5 CS handle 'object in use'.
Basically, in order to make a DDL change, you need exclusive access on
the objects it touches. (This may or may not have always been the
case). The safest way is to ensure exclusive access when making ddl
changes.
Firebird 2 does allow you to make some changes like adding FK
constraints even if you don't have exclusive access, however they
don't come into effect until it does get exclusive access. See the
release notes for more information.
Adam
wrote:
>Not at all. I am saying that there has been issues with the installers
> No guardian running. Are you suggesting that you run CS and have no
> updating problems?
in the past installing guardian against a classic install. The
guardian process was designed to watch the firebird server process and
restart it if it crashed. Of course if you use services, you could
always configure failure actions to restart the service.
But then again that wasn't your original question. You were enquiring
over whether anything had changed between IB and FB 1.5. The obvious
answer is yes. IB didn't even have classic on windows. From my
understanding, there should be no difference between the way FB 1.5 SS
and FB 1.5 CS handle 'object in use'.
Basically, in order to make a DDL change, you need exclusive access on
the objects it touches. (This may or may not have always been the
case). The safest way is to ensure exclusive access when making ddl
changes.
Firebird 2 does allow you to make some changes like adding FK
constraints even if you don't have exclusive access, however they
don't come into effect until it does get exclusive access. See the
release notes for more information.
Adam