Peter Ypenburg wrote:

> Is it possible for two users who run the following SQL at the exact same
> time (each in their own transaction) to get the same value back from a
> generator. The SQL is as follows:
>
> SELECT GEN_ID(EXPORTLOCK_SEQ, -1)
> FROM RDB$DATABASE

Only if someone manages to execute a
select gen_id(EXPORTLOCK_SEQ, +1) from rdb$database
between your two statements.


--
Aage J.