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