The easiest way to see this is to BEGIN READ ONLY & then attempt an insert.
Execute either of COMMIT AND CHAIN or ROLLBACK AND CHAIN & attempt the insert a
second time
This seems incorrect. The documentation should at least point out this behavior
if it's intended
Discovered while looking into issue here:
https://github.com/citusdata/citus/pull/2733
For completeness I'll quote the example code to demonstrate the issue:
postgres=# create table events_table (id integer primary key, user_id integer);
CREATE TABLE postgres=# create table users_table_ref (id