--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...> wrote:

> Yes, we just had a thread today along these lines. With most PSQL changes,
> clients who are already connected will continue to use "old" PSQL code
> because this is seen as an important way to maintain data consistency per
> user.

I could understand that approach... except that I'm the only user connected, and "data consistency per user" (i.e me) seems to be out-the-window if it's using the 'old' PSQL instead of the new (because it doesn't work)!

> All structural changes to databases should really be done without anyone
> connected (other than the database creator/designer/owner doing the
> changes).

Well this is basically the case. We have a process in place (using the FB service api) that includes stopping and restarting the FB service if metadata changes fail on constraints (when caused by other users being connected at the same time). A bit brutal but successful (on windows... but not Mac or Linux with the services api being broken... at least in FB 1.5... :( ).