Re: RESET SESSION

Your patch has been added to the PostgreSQL unapplied patches list at:

http://momjian.postgresql.org/cgi-bin/pgpatches

It will be applied as soon as one of the PostgreSQL committers reviews
and approves it.

---------------------------------------------------------------------------

Marko Kreen wrote:
> This is draft version, for discussion.
>
> New commands:
>
> CLOSE ALL
> DEALLOCATE ALL
> RESET PLANS
> RESET TEMPS -- please suggest better name
>
> RESET SESSION
>
> So in the end RESET SESSION basically executes following commands:
>
> ABORT;
> DEALLOCATE ALL;
> CLOSE ALL;
> RESET ALL;
> SET SESSION AUTHORIZATION DEFAULT;
> UNLISTEN *;
> RESET TEMPS;
> RESET PLANS;
>
>
> I think CLOSE ALL and DEALLOCATE ALL are useful in their own,
> without considering poolers. They just make user lives easier.
> The ALL just fits there.
>
> RESET PLANS and RESET TEMPS are for the principle that components
> for RESET SESSION should be available for users for special-case
> situations and fine-tuning poolers. Also they add very little complexity.
> (RESET PLANS could be useful its awn also).
>
> Todo:
>
> * Docs
> * Disallow some commands inside TX?
> * DEALLOCATE PREPARE ALL gives bison conflicts. is it needed?
> * Send more details to client. Variants:
> - CommandComplete: "RESET XXX", "CLOSE ALL", "DEALLOCATE ALL"
> (CLOSE name and DEALLOCATE name would be good in normal case too,
> that help anyone who wants to track what exists)
> - RESET SESSION should send ParamStatus of all parms
>
>
> --
> marko

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +