Generational RDBMS' don't lock like this.

It is possible to deadlock a generational database with updates on two
(or more) tables, but it generally requires careful setup and bad
(good?) luck.

Can you be more precise as to the symptoms and the nature of the
transaction?

On Tue, 2005-11-29 at 11:11 +0530, Hemant.Sapre@...
wrote:

> Hi,
>
>
>
> Does Firebird have GLOBAL TEMPORARY table concept. We are facing
> problems in a multiple user environment where users are writing to a
> single table concurrently. The page is locked due to Lock contention.
> Can this problem be overcome by any other means?
>
>
>
> Thanks and Regards,
>
> Hemant.