Re: show all;

> The problem is that they don't want to change the log levels. They are
> using BEGIN;COMMIT; as an automatic thing in the PHP interface to close
> any open transaction before passing the persistent connection to another
> user. This is a special case.

My original question has not been answered. Is BEGIN;COMMIT; the proper
way for persistent connections to abort any transaction left open?

ABORT throws a message in the log each time if there is no open
transaction, which seems wrong for this usage.

BEGIN;COMMIT will throw an elog message if there is an open
transaction, but that is OK because it is quite rare to happen.

With this and RESET ALL, persistent connections will be safe.

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