MIME-Version: 1.0
In-Reply-To: <CANzqJaAsAY_u-OoZHojfk6E2bjjndqNEu2qNqy7-Xi-CPbe=_g@mail.gmail.com>
References: <D78EPGDRGTYO.1C8SB09QLCOHE@runxiyu.org> <CANzqJaAsAY_u-OoZHojfk6E2bjjndqNEu2qNqy7-Xi-CPbe=_g@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Wed, 22 Jan 2025 07:37:17 -0700
Message-ID: <CAKFQuwa9Z3OiEHA6ZLMdJc=ScaBy=TVL5wMUBVXUtOY08r1tXw@mail.gmail.com>
Subject: Re: Automatic deletion of orphaned rows
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000003701d3062c4c6e86"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwa9Z3OiEHA6ZLMdJc%3DScaBy%3DTVL5wMUBVXUtOY08r1tXw%40mail.gmail.com>
Precedence: bulk

--0000000000003701d3062c4c6e86
Content-Type: text/plain; charset="UTF-8"

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.

--0000000000003701d3062c4c6e86
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wednesday, January 22, 2025, Ron Johnson &lt;<a href=3D"mailto:ronljohns=
onjr@gmail.com">ronljohnsonjr@gmail.com</a>&gt; wrote:<blockquote class=3D"=
gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-=
left:1ex"><div dir=3D"ltr"><div class=3D"gmail_quote"><blockquote class=3D"=
gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(20=
4,204,204);padding-left:1ex">
<br>
I therefore propose a feature, to be able to specify in a table schema<br>
that a row should be deleted if orphaned.</blockquote><div><br></div><div>F=
or one thing, rows <b>can&#39;t</b>=C2=A0be orphaned if there&#39;s a forei=
gn key reference.=C2=A0</div></div></div></blockquote><div><br></div><div>T=
he description was correct even though using probably imprecise terminology=
.=C2=A0 The basic goal is to delete childless parents.</div><div><br></div>=
<div>David J.</div><div><br></div>

--0000000000003701d3062c4c6e86--