Re: [GENERAL] The value returned by autoinc ?

From: Clark Evans <clark(dot)evans(at)manhattanproject(dot)com>
To: Silvio Emanuel Barbosa de Macedo <smacedo(at)inescn(dot)pt>
Cc: Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il>, pgsql general mailing list <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] The value returned by autoinc ?
Date: 1999-03-15 10:10:53
Message-ID: 36ECDCAD.63E72D41@manhattanproject.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Herouth Maoz 1999-03-15 10:15:34 Re: [GENERAL] The value returned by autoinc ?
Previous Message Silvio Emanuel Barbosa de Macedo 1999-03-15 09:59:28 Re: [GENERAL] The value returned by autoinc ?