Re: [GENERAL] The value returned by autoinc ? - Mailing list pgsql-general

From Clark Evans
Subject Re: [GENERAL] The value returned by autoinc ?
Date
Msg-id 36ECDCAD.63E72D41@manhattanproject.com
Whole thread Raw
In response to Re: [GENERAL] The value returned by autoinc ?  (Silvio Emanuel Barbosa de Macedo <smacedo@inescn.pt>)
List pgsql-general
Silvio Emanuel Barbosa de Macedo wrote:
> 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...

It should be a counter attached to your session, so
there wouldn't be any problems, since you can only
have one thread in each session.

Clark

pgsql-general by date:

Previous
From: Silvio Emanuel Barbosa de Macedo
Date:
Subject: Re: [GENERAL] The value returned by autoinc ?
Next
From: Herouth Maoz
Date:
Subject: Re: [GENERAL] The value returned by autoinc ?