| From: | John DeSoi <desoi(at)pgedit(dot)com> |
|---|---|
| To: | Tim Hart <tjhart(at)mac(dot)com> |
| Cc: | "Antonis Christofides" <anthony(at)itia(dot)ntua(dot)gr>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: User privileges in web database applications |
| Date: | 2006-06-30 13:44:56 |
| Message-ID: | 5C816A7C-9F58-4133-B46D-C6223E3657B7@pgedit.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Jun 29, 2006, at 5:58 PM, Tim Hart wrote:
> I'm coming in a bit late to this conversation, so forgive me if
> I've missed
> something. Isn't this problem the reason that connection pools were
> created?
>
> In a connection pool, connections are only associated with a
> particular
> user for the duration of a transaction. Once the transaction is
> complete,
> the connection goes back to the pool.
Right, this is standard operating procedure. But the original poster
mentioned tying the connection to a particular web user/session. In
other words, one connection per user.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-06-30 14:17:10 | Re: Notes on converting from MySQL 5.0.x to PostgreSQL 8.1.4 |
| Previous Message | Martijn van Oosterhout | 2006-06-30 13:21:42 | Re: pg_restore: [archiver] could not open input file |