From: | "A(dot)M(dot)" <agentm(at)themactionfaction(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [PATCHES] Implementing RESET CONNECTION ... |
Date: | 2006-04-25 14:28:27 |
Message-ID: | 38152.12.15.136.26.1145975307.squirrel@webmail.webopticon.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
To complete the connection pooling for multiple users, it would be great
to have a protocol level option to change roles semi-permanently (to
reduce permissions). RESET SESSION AUTHORIZATION would then bounce back to
that (new, set) role until another protocol-level role "rollback". This
would allow completely reusable connections per database while maintaining
a real sandbox for each connection.
On Tue, April 25, 2006 10:19 am, Bruce Momjian wrote:
>
> OK, what would people like done with this patch? Our TODO list has:
>
>
> * -Add RESET CONNECTION command to reset all session state
>
>
> This would include resetting of all variables (RESET ALL), dropping of
> temporary tables, removing any NOTIFYs, cursors, open transactions,
> prepared queries, currval()s, etc. This could be used for connection
> pooling. We could also change RESET ALL to have this functionality. The
> difficult of this features is allowing RESET ALL to not affect changes
> made by the interface driver for its internal use. One idea is for this
> to be a protocol-only feature. Another approach is to notify the protocol
> when a RESET CONNECTION command is used.
>
> This patch does everything except reset currval(), but the big missing
> item is that it doesn't handle the protocol issues outlined in the TODO
> item. However, there also has been very little discussion on exactly how
> the protocol stuff would work.
>
> Should we add it for 8.2 and see if we get any problem reports?
From | Date | Subject | |
---|---|---|---|
Next Message | REYNAUD Jean-Samuel | 2006-04-25 14:32:57 | FOR UPDATE lock problem ? |
Previous Message | Bruce Momjian | 2006-04-25 14:19:41 | Re: [PATCHES] Implementing RESET CONNECTION ... |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2006-04-25 14:48:10 | Re: Documentation patch: change a name in a grammar rule to |
Previous Message | Bruce Momjian | 2006-04-25 14:19:41 | Re: [PATCHES] Implementing RESET CONNECTION ... |