Re: Automatic deletion of orphaned rows - Mailing list pgsql-general

From David G. Johnston
Subject Re: Automatic deletion of orphaned rows
Date
Msg-id CAKFQuwa9Z3OiEHA6ZLMdJc=ScaBy=TVL5wMUBVXUtOY08r1tXw@mail.gmail.com
Whole thread Raw
In response to Re: Automatic deletion of orphaned rows  (Ron Johnson <ronljohnsonjr@gmail.com>)
Responses Re: Automatic deletion of orphaned rows
List pgsql-general
On Wednesday, January 22, 2025, Ron Johnson <ronljohnsonjr@gmail.com> wrote:

I therefore propose a feature, to be able to specify in a table schema
that a row should be deleted if orphaned.

For one thing, rows can't be orphaned if there's a foreign key reference. 

The description was correct even though using probably imprecise terminology.  The basic goal is to delete childless parents.

David J.

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Automatic deletion of orphaned rows
Next
From: Greg Sabino Mullane
Date:
Subject: Re: Automatic deletion of orphaned rows