On Wed, Jan 22, 2025 at 9:37 AM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Wednesday, January 22, 2025, Ron Johnson
> 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
On Wed, Jan 22, 2025 at 2:00 AM Runxi Yu wrote:
> I therefore propose a feature, to be able to specify in a table schema
> that a row should be deleted if orphaned.
>
I think you mean "childless" rows, as "orphaned" has a different meaning
traditionally.
When and how would this deletion take pl
On Wednesday, January 22, 2025, Ron Johnson 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 thou
On Wed, Jan 22, 2025 at 2:00 AM Runxi Yu wrote:
> Hi,
>
> While writing a new program, I encountered the following:
>
> I have three tables: A, B, and X. Rows in X are referenced by A and/or B
> via foreign keys, one or more times. I would like to delete all orphaned
> rows in X, i.e. a row in X
Hi,
While writing a new program, I encountered the following:
I have three tables: A, B, and X. Rows in X are referenced by A and/or B
via foreign keys, one or more times. I would like to delete all orphaned
rows in X, i.e. a row in X is deleted if and only if it is no longer
referenced by any ro
