| From: | Gustavo Amarilla Santacruz <gusamasan(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Postgresql - Currval Vs Session Pool |
| Date: | 2013-06-09 15:59:31 |
| Message-ID: | CAKc1ktUJy=gazYN-PwR8O9xzoEsfS5i1_YfKFbHP+qyHp=LJwQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Johnston | 2013-06-09 16:47:54 | Re: Postgresql - Currval Vs Session Pool |
| Previous Message | dinesh kumar | 2013-06-09 13:17:40 | Re: Postgres 8.4 stopped working---Please urgent help needed |