Postgres Pro
Downloads
Home   >   mailing lists

Re: Truncate DUMMY_mid is blocked DELETE DUMMY_init TABLE - Mailing list pgsql-admin

From Tom Lane
Subject Re: Truncate DUMMY_mid is blocked DELETE DUMMY_init TABLE
Date
Msg-id 914349.1717623585@sss.pgh.pa.us
Whole thread Raw
In response to Truncate DUMMY_mid is blocked DELETE DUMMY_init TABLE  (M Sarwar <sarwarmd02@outlook.com>)
Responses Re: Truncate DUMMY_mid is blocked DELETE DUMMY_init TABLE
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: M Sarwar
Date:
Subject: Truncate DUMMY_mid is blocked DELETE DUMMY_init TABLE
Next
From: M Sarwar
Date:
Subject: Re: Truncate DUMMY_mid is blocked DELETE DUMMY_init TABLE