Hi Tom,
I checked both the tables, DUMMY_MID as well as DUMMY_INIT and they do not have relationship at all.
These 2 tables number of columns and the column names are the same. The data is copied from one another. That should not matter as long as there is no foreign key relationship to each others.
Thanks,
Sarwar
From: Tom Lane <tgl@sss.pgh.pa.us>
Sent: Wednesday, June 5, 2024 5:39 PM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Truncate DUMMY_mid is blocked DELETE DUMMY_init TABLE
M Sarwar <sarwarmd02@outlook.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