From: Tom Lane <tgl@sss.pgh.pa.us>
To: steve@tusol.co.uk
cc: PostGreSQL <pgsql-novice@postgresql.org>
Subject: Re: Advice on foreign key and cascading delete design - postgresql
 12.6
In-reply-to: <c1cfdf4054e8480d28fbf7fb2e15912d3996ee69.camel@tusol.co.uk>
References: <c1cfdf4054e8480d28fbf7fb2e15912d3996ee69.camel@tusol.co.uk>
Comments: In-reply-to "Steve Tucknott (TuSol)" <steve@tusol.co.uk>
	message dated "Tue, 13 Apr 2021 13:40:51 +0100"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <3190279.1618325238.1@sss.pgh.pa.us>
Date: Tue, 13 Apr 2021 10:47:18 -0400
Message-ID: <3190280.1618325238@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/3190280.1618325238%40sss.pgh.pa.us>
Precedence: bulk

"Steve Tucknott (TuSol)" <steve@tusol.co.uk> writes:
> I have a few tables that are subservient to multiple other tables
> (notes, addresses, attached documents etc).
> These tables carry the 'owning' table name and its record's PK.

> I can manually keep these tables tidy and avoid orphans, but is there a
> way within postgresql to reference these tables on a FK constraint to
> automatically delete the subservient recs when the parent is deleted?

Maybe I'm missing something, but aren't you just looking for the
ON DELETE CASCADE option of foreign key constraints?

			regards, tom lane