M Sarwar <sarwarmd02(at)outlook(dot)com> writes:> I am truncating the table DUMMY_mid .> Truncate is getting struck due to DELETE operation on the table DUMMY_init.
Maybe you have foreign keys connecting those tables?
regards, tom lane