esrefatak wrote:

>>But essential to maintain data integrity. If one connection changes a
>>fundamental link, while the other is removing the validated data ....
>
> But, Firebird is RDBMS like PostgreSQL, Oracle etc.
> It should resolve.

As I understand it, PostgreSQL will allow changes that break the
database and it's up to you to sort the mess out! Personally I do not go
for making changes to the structure of a live database anyway, but
ensuring that the database does not get screwed IF you change the
structure seems like a good idea to me ?

Preventing TWO people making structural changes at the same time is not
easy to do, so restricting those changes to an engineering mode where
there can only be one set of changes to be managed seems a better idea
than allowing potentially conflicting activity - which in many cases can
NOT be resolved by commit/rollback activity. As I understand it.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services