Truncate DUMMY_mid is blocked DELETE DUMMY_init TABLE

[M Sarwar <sarwarmd02@xxxxxxxxxxx>]

Hello,

Today I have an interesting observation.

I am truncating the table DUMMY_mid .

Truncate is getting struck due to DELETE operation on the table DUMMY_init.

When I take a look at the PG_STAT_ACTIVITY table, it is confirmed that the TRUNCATE is blocked by  DELETE on DUMMY_INIT table.

This seems to be strange to me.

Thanks,

Sarwar