Re: DELETE trigger, direct or indirect?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: Dominique Devienne <ddevienne(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: DELETE trigger, direct or indirect?
Date: 2023-02-16 16:55:28
Message-ID: CAKFQuwZ-f+ukUkai64mj_SFFSW_WC0nr+1SmzEkvauf+qASfhg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Feb 16, 2023 at 9:46 AM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 2/16/23 05:23, Dominique Devienne wrote:
> > Hi. This is a bit unusual. We have a foreign key between two tables,
> > with ON DELETE CASCADE, to preserve referential integrity. But we
> > apparently also need to preserve the severed reference (by natural key,
> > i.e. its name), to later on reconnect the two entities after-the-fact,
> > should the parent row re-appear later on (in the same transaction or not
> > it still unclear).
>
> This is going to need a more detailed description of the relationship
> between the two tables:
>
> 1) The actual FK relationship.
>
> 2) What "...preserve the severed reference (by natural key, i.e. its
> name)" means?
>
> 3) What information will be used to reconnect the child rows to the
> parent rows?
>
>
Maybe the OP should be using ON DELETE SET NULL instead of CASCADE?

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2023-02-16 16:59:37 Re: DELETE trigger, direct or indirect?
Previous Message Jonathan S. Katz 2023-02-16 16:48:22 Re: Support logical replication of DDLs