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

From Peter Eisentraut
Subject Re: BUG #15977: Inconsistent behavior in chained transactions
Date
Msg-id fd496708-6158-4d7b-78e7-3f40770b1054@2ndquadrant.com
Whole thread Raw
In response to Re: BUG #15977: Inconsistent behavior in chained transactions  (fn ln <emuser20140816@gmail.com>)
Responses Re: BUG #15977: Inconsistent behavior in chained transactions
List pgsql-hackers
On 2019-09-09 05:58, fn ln wrote:
> Confirmed. Thank you all for your help.
> 
> The only concern is that this test:
> 
>    SET TRANSACTION READ WRITE\; COMMIT AND CHAIN;  -- error
>    SHOW transaction_read_only;
> 
>    SET TRANSACTION READ WRITE\; ROLLBACK AND CHAIN;  -- error
>    SHOW transaction_read_only;
> 
> makes more sense with READ ONLY because default_transaction_read_only is
> off at this point.

Oh you're right.  Fixed.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [HACKERS] CLUSTER command progress monitor
Next
From: Peter Eisentraut
Date:
Subject: Re: msys2 vs pg_upgrade/test.sh