Re: show all; - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: show all;
Date
Msg-id 200106020117.f521HOo14054@candle.pha.pa.us
Whole thread Raw
In response to Re: show all;  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: show all;  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
> > 1) rolls TX back, so you are not in any TX
>
> This I do not agree with; it ties together two concepts that are better
> kept separate.  (If SET were under transaction control, my opinion might
> be different ... but it isn't.)  There is nothing wrong with sending a
> ROLLBACK if you want to be sure you are not in a transaction block.
> Further, there could be situations where you want to RESET the conf vars
> without forcing a rollback.

I agree it links two unrelated items.

The problem with ROLLBACK is that it throws an error into the log if
there is not transaction.  This is for persistent connections reset.
How about ROLLBACK QUIET?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: show all;
Next
From: Tom Lane
Date:
Subject: Re: show all;