Re: Nextval & Currval

On Tue, Jun 10, 2008 at 7:14 AM, Shavonne Marietta Wijesinghe
<shavonne.marietta@studioform.it> wrote:
> I managed to make the connection work. I tried inserting records from 2
> computers. It works fine untill 2 computers insert a nextwall one after
> another.
>
> Here is a small example of what i see in my DB
>
> ++++++|+++++++++++++++++|++++++++++
>     N °    |       Session                |   Number
> ++++++|+++++++++++++++++ |++++++++++
>   1        |       DB last record       |   269
>   2        |       PC A (nextval )      |   270
>   3        |       PC A (nextval )      |   271
>   4        |       PC A (currval )       |   271
>   5        |       PC A (nextval )      |   272
>   6        |       PC A (nextval )      |   273
>   7        |       PC B (nextval )      |   274
>   8        |       PC A (currval )       |   274
>   9        |       PC B (nextval )      |   275
>   10      |       PC A (nextval )       |   276

Are you using connection pooling?  Could it be that session PC A on
the client side is switching connections between 6 and 8?  What to you
get from pg_backend_pid() in the two instances of time 6 and 8?