Re: Trigger violates foreign key constraint

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: Pavel Luzanov <p(dot)luzanov(at)postgrespro(dot)ru>, Aleksander Alekseev <aleksander(at)timescale(dot)com>, pgsql-hackers(at)postgresql(dot)org, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Subject: Re: Trigger violates foreign key constraint
Date: 2024-04-07 18:52:23
Message-ID: 2899874.1712515943@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> writes:
> Patch v3 is attached.

I agree with documenting this hazard, but I think it'd be better
to do so in the "Triggers" chapter. There is no hazard unless
you are writing user-defined triggers, which is surely far fewer
people than use foreign keys. So I suggest something like the
attached.

regards, tom lane

Attachment Content-Type Size
v4-0001-Document-foreign-key-internals.patch text/x-diff 1.1 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Lakhin 2024-04-07 19:00:00 Re: Add SPLIT PARTITION/MERGE PARTITIONS commands
Previous Message Alvaro Herrera 2024-04-07 18:41:41 Re: MultiXact\SLRU buffers configuration