Re: show all; - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: show all;
Date
Msg-id 200106021630.f52GUXA13107@candle.pha.pa.us
Whole thread Raw
In response to Re: show all;  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
> 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@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: Bruce Momjian
Date:
Subject: Re: Re: AW: [HACKERS] Re: Support for %TYPE in CREATE FUNCTION