Postgres Pro
Downloads
Home   >   mailing lists

Re: TRUNCATE ONLY with foreign keys and triggers disabled - Mailing list pgsql-general

From Laurenz Albe
Subject Re: TRUNCATE ONLY with foreign keys and triggers disabled
Date
Msg-id 6776dc7beaf591a684d089db4c77407b7a2866c4.camel@cybertec.at
Whole thread Raw
In response to Re: TRUNCATE ONLY with foreign keys and triggers disabled  (Dimitrios Apostolou <jimis@gmx.net>)
Responses Re: TRUNCATE ONLY with foreign keys and triggers disabled
List pgsql-general
Tree view 
On Mon, 2025-04-14 at 17:05 +0200, Dimitrios Apostolou wrote:
> I meant the *referencing* table has just been
> populated. I'm trying to delete the *referenced* table and I get the
> error.

That would break the foreign key constraint, right?
PostgreSQL cannot allow that.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Dimitrios Apostolou
Date:
Subject: Re: TRUNCATE ONLY with foreign keys and triggers disabled
Next
From: Adrian Klaver
Date:
Subject: Re: TRUNCATE ONLY with foreign keys and triggers disabled