Hello, all.
In the PostgreSQL documentation I found "currval: Return the value most recently obtained by nextval for this sequence in the current session ...."
In other documentations (pgpool, for example), I found "Connection Pooling
pgpool-II saves connections to the PostgreSQL servers, and reuse them whenever a new connection with the same properties (i.e. username, database, protocol version) comes in. It reduces connection overhead, and improves system's overall throughput"
Then, I have the following question: PostgreSQL differentiates between sessions created for the same user?
Background
==========
- I, traditionalmente, have several user in a web application (user table, for example); but I use only one postgresql-db-user to get connetions to database
- If a CREATE (CRUD) operation uses a head-detail couple of tables, then in a transaction: data in HEAD table is inserted; next, the value for the primary key is achieved from currval function; next references to head table is inserted in detail table.
Other questions
===============
- If I use a "bd_user" user to get connections to PostgreSQL and I use connetions Pool; if CONNECTION_01 and CONNECTION_02 concurrently try to get value from "currval" function, what happens?
- Exist best practices to do what I trying.
Thank you, in advance.
------------------------
Gustavo Amarilla