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@momjian.us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

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