Re: Max connections reached without max connections reached - Mailing list pgsql-general

From Michael Lewis
Subject Re: Max connections reached without max connections reached
Date
Msg-id CAHOFxGrBePEuzcZriAVmEAdYo6FjxBhaSBMpSChZmy=ipa_QLA@mail.gmail.com
Whole thread Raw
In response to Re: Max connections reached without max connections reached  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: Max connections reached without max connections reached  (Rob Sargent <robjsargent@gmail.com>)
List pgsql-general
On Wed, Dec 1, 2021 at 3:52 PM Rob Sargent <robjsargent@gmail.com> wrote:
Also be on the look-out for begin trans; begin trans; etc  I read Kumar's report as nested transactions.  If your gang is doing a transaction per row, they need a kick in the rear.  Anyone not closing those needs a pink slip. 

I have seen the second attempt at calling begin seem to be ignored with "WARNING:  there is already a transaction in progress" similar to calling rollback without a transaction open. Are you stating or suggesting that calling begin a second time actually is more similar to creating a savepoint? That would be rather unexpected from the messaging, at least for me.

pgsql-general by date:

Previous
From: Kyotaro Horiguchi
Date:
Subject: Re: ssl_crl_file Certificate Revocation List doesn't work for postgresql 11
Next
From: Yi Sun
Date:
Subject: Re: ssl_crl_file Certificate Revocation List doesn't work for postgresql 11