Re: [GENERAL] The value returned by autoinc ?

[Silvio Emanuel Barbosa de Macedo]

        Thank you for your answer. 
        Still, one doubt.

On Mon, 15 Mar 1999, Herouth Maoz wrote:
>   INSERT...
>   SELECT currval( 'seq_name' );
>...
> It will also give you the
>correct number even if between the INSERT and the SELECT, another process
>or another connection also made an insert.
>Herouth

If there is an insert between my INSERT and SELECT, won't the counter be
increased ? The only way I can understand this is the transaction locks
inserts... so, in fact there could not exist another insert...

Am I wrong (or better, how wrong am I :) ) ?  

Thanks again!


,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
`````````````````````````````````````````````
Silvio Emanuel Nunes Barbosa de Macedo
mailto:[EMAIL PROTECTED]

INESC - Porto - Grupo CAV
Pc da Republica, 93 R/C   Tel:351 2 209 42 21
4000 PORTO  PORTUGAL      Fax:351 2 208 41 72