PostgreSQL Constraints and Foreign Keys - Dropping Tables

From: Sbob <sbob(at)quadratum-braccas(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: PostgreSQL Constraints and Foreign Keys - Dropping Tables
Date: 2022-12-08 21:36:27
Message-ID: 134db88e-0735-1e96-cd94-3ee5bbaf8fac@quadratum-braccas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Is this true?

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

Thanks in advance

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2022-12-08 21:40:10 Re: PostgreSQL Constraints and Foreign Keys - Dropping Tables
Previous Message Laurenz Albe 2022-12-08 20:46:12 Re: backend_xid and backend_xmin