PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15977
PG Version12beta3
OSWindows
Opened2019-08-25 06:11:05+00
Reported bymtlh kdvt
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15977
Logged by:          mtlh kdvt
Email address:      (redacted)
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

Messages

DateAuthorSubject
2019-08-25 06:11:05+00PG Bug reporting formBUG #15977: Inconsistent behavior in chained transactions
2019-08-25 09:11:09+00Fabien COELHORe: BUG #15977: Inconsistent behavior in chained transactions
2019-08-28 19:29:26+00fn lnRe: BUG #15977: Inconsistent behavior in chained transactions
2019-08-29 06:30:07+00Fabien COELHORe: BUG #15977: Inconsistent behavior in chained transactions
2019-08-29 07:24:11+00Fabien COELHORe: BUG #15977: Inconsistent behavior in chained transactions
2019-08-29 11:39:39+00fn lnRe: BUG #15977: Inconsistent behavior in chained transactions
2019-08-29 12:10:06+00Fabien COELHORe: BUG #15977: Inconsistent behavior in chained transactions
2019-08-29 12:35:43+00fn lnRe: BUG #15977: Inconsistent behavior in chained transactions
2019-08-29 13:01:11+00Fabien COELHORe: BUG #15977: Inconsistent behavior in chained transactions
2019-08-29 13:55:47+00fn lnRe: BUG #15977: Inconsistent behavior in chained transactions
2019-08-29 14:58:18+00Fabien COELHORe: BUG #15977: Inconsistent behavior in chained transactions