Re: postgres_fdw: dead lock in a same transaction when postgres_fdw server is lookback

2022-10-01 Thread Laurenz Albe
On Sat, 2022-10-01 at 04:02 +, Xiaoran Wang wrote: > I created a postgers_fdw server lookback as the test does. Then run the > following SQLs > > [create a foreign server via loopback and manipulate the same data locally > and via foreign table] > > Then the transaction got stuck. Should th

postgres_fdw: dead lock in a same transaction when postgres_fdw server is lookback

2022-09-30 Thread Xiaoran Wang
Hi, I created a postgers_fdw server lookback as the test does. Then run the following SQLs create table t1(c0 int); insert into t1 values(1); create foreign table ft1( c0 int ) SERVER loopback OPTIONS (schema_name 'public', table_name 't1'); Then started a transaction that runs queries on b