Re: RESET SESSION

Tom Lane wrote:
> "Marko Kreen" <markokr(at)gmail(dot)com> writes:
> > RESET TEMPS -- please suggest better name
>
> RESET TEMP (should allow RESET TEMPORARY too). I see no reason to add
> a new keyword when the existing one will do fine.
>
> > So in the end RESET SESSION basically executes following commands:
>
> > ABORT;
>
> I object to having RESET SESSION include an ABORT. That will make it
> a transaction control statement and complicate matters for a whole
> lot of things. If you don't know whether you're in a transaction or
> not, you can send ABORT for yourself, but in practice I think most
> client code already tracks that (or easily can).

It seems strange RESET SESSION would not terminate open transactions,
but on the other hand calling RESET SESSION in a transaction seems odd
too.

I think we should at least throw an error if someone tries RESET SESSION
inside a transaction, and hopefully administrators will realize they
have a problem. Perhaps we can even offer a hint how to close open
transactions.

--
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. +