Re: Automatic deletion of orphaned rows

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Automatic deletion of orphaned rows
Date: 2025-01-22 14:37:17
Message-ID: CAKFQuwa9Z3OiEHA6ZLMdJc=ScaBy=TVL5wMUBVXUtOY08r1tXw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday, January 22, 2025, Ron Johnson <ronljohnsonjr(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Sabino Mullane 2025-01-22 15:11:26 Re: Automatic deletion of orphaned rows
Previous Message Ron Johnson 2025-01-22 14:03:06 Re: Automatic deletion of orphaned rows