Re: PostgreSQL Constraints and Foreign Keys - Dropping Tables - Mailing list pgsql-admin

From David G. Johnston
Subject Re: PostgreSQL Constraints and Foreign Keys - Dropping Tables
Date
Msg-id CAKFQuwb1NBGVMyNk-TZWv2CNZxMJFYQLws+rj-7F+742K==QaQ@mail.gmail.com
Whole thread Raw
In response to PostgreSQL Constraints and Foreign Keys - Dropping Tables  (Sbob <sbob@quadratum-braccas.com>)
List pgsql-admin
On Thu, Dec 8, 2022 at 2:36 PM Sbob <sbob@quadratum-braccas.com> wrote:
I just saw a post indicating that PostgreSQL Foreign Keys and
Constraints are actually managed via triggers, therefore instead of
doing a DROP TABLE CASCADE I could just disable triggers.

Those two things don't produce the same end result...


If so it 'feels' like there may be dangerous side effects, any thoughts
on any cautions and gotcha's to this approach?


Why did you add constraints/foreign keys in the first place?

David J.

pgsql-admin by date:

Previous
From: Sbob
Date:
Subject: PostgreSQL Constraints and Foreign Keys - Dropping Tables
Next
From: SASIKUMAR Devaraj
Date:
Subject: How to speed WAL apply in destination