Re: Eliminating SPI / SQL from some RI triggers - take 3

Sandro Santilli <strk@kbt.io>

From: Sandro Santilli <strk@kbt.io>

To: Amit Langote <amitlangote09@gmail.com>

Cc: Tomas Vondra <tomas@vondra.me>, Junwang Zhao <zhjwpku@gmail.com>, Pavel Stehule <pavel.stehule@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2026-04-10T18:35:36Z

Lists: pgsql-hackers

On Fri, Apr 10, 2026 at 01:14:11PM +0900, Amit Langote wrote:
> 
> I have just pushed 0001 which you'll find in master as 34a3078629.

No crash with commit 2a3d2f9f68da0c430c497bf29f60373f5214307d
(which includes 34a3078629).

Thank you !

--strk;

  Libre GIS consultant/developer 🎺
  https://strk.kbt.io/services.html

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Fix some const qualifier use in ri_triggers.c
- 1b9dc2cb7574 19 (unreleased) landed
doc: Improve consistency of parallel vacuum description.
- 2a3d2f9f68da 19 (unreleased) cited
Move afterTriggerFiringDepth into AfterTriggersData
- d6e96bacd3c0 19 (unreleased) landed
Fix typo left by 34a30786293
- 03029409b409 19 (unreleased) landed
Fix RI fast-path crash under nested C-level SPI
- 34a307862930 19 (unreleased) landed
Add nkeys parameter to recheck_matched_pk_tuple()
- e1cc57fabd6c 19 (unreleased) landed
Fix deferred FK check batching introduced by commit b7b27eb41a5
- 5c54c3ed1b93 19 (unreleased) landed
Optimize fast-path FK checks with batched index probes
- b7b27eb41a5c 19 (unreleased) landed
Make FastPathMeta self-contained by copying FmgrInfo structs
- edee5634564d 19 (unreleased) landed
Add fast path for foreign key constraint checks
- 2da86c1ef9b5 19 (unreleased) landed