BUG #15977: Inconsistent behavior in chained transactions - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #15977: Inconsistent behavior in chained transactions
Date
Msg-id 15977-f4eb49ebdcacc65b@postgresql.org
Whole thread Raw
Responses Re: BUG #15977: Inconsistent behavior in chained transactions
Re: BUG #15977: Inconsistent behavior in chained transactions
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15977
Logged by:          mtlh kdvt
Email address:      emuser20140816@gmail.com
PostgreSQL version: 12beta3
Operating system:   Windows
Description:

When a ROLLBACK AND CHAIN command is executed in the implicit transaction
block, a new transaction will be started:
   db=# ROLLBACK AND CHAIN;
   WARNING:  there is no transaction in progress
   ROLLBACK
   db=# ROLLBACK AND CHAIN;
   ROLLBACK

However, a COMMIT AND CHAIN command won't start a new transaction:
   db=# COMMIT AND CHAIN;
   WARNING:  there is no transaction in progress
   COMMIT
   db=# COMMIT AND CHAIN;
   WARNING:  there is no transaction in progress
   COMMIT


pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: PostgreSQL12 crash bug report
Next
From: Fabien COELHO
Date:
Subject: Re: BUG #15977: Inconsistent behavior in chained transactions