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