Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vB3ex-009nKO-6V for pgsql-hackers@arkaria.postgresql.org; Tue, 21 Oct 2025 04:07:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1vB3ew-006Jeg-6K for pgsql-hackers@arkaria.postgresql.org; Tue, 21 Oct 2025 04:07:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vB3ev-006JeX-T2 for pgsql-hackers@lists.postgresql.org; Tue, 21 Oct 2025 04:07:40 +0000 Received: from mail-pj1-x1030.google.com ([2607:f8b0:4864:20::1030]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vB3es-003M3b-2G for pgsql-hackers@postgresql.org; Tue, 21 Oct 2025 04:07:40 +0000 Received: by mail-pj1-x1030.google.com with SMTP id 98e67ed59e1d1-33d962c0e9aso1655882a91.0 for ; Mon, 20 Oct 2025 21:07:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1761019656; x=1761624456; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=XKYICs2FgVs0B/gNsszFx1e+o/+DAZGMx0FA5uzNqFs=; b=eOveXCEiy36fWLgW7pWi3N3TQRv3ff+VjWWgeW/4L3JYJ90q8XSyWM/ANe0hMYGjO6 ppyo87l3OI6ftfF7S5CGRqkoZZmIvzDOBMVcXSrzJNcV2Eblz41we8vgxBhNMBmVDqU1 Im4V2jD6GwA29rFDnMfusMNty3E2Lwp2ODewx0esQVfHC/3J8FQC21eHCDPpLzELGbrk 6bSwyXAwtppLnjb4XG/hbBPajYTSceDG0w8m43eXNh+ykRsuS6kkz44if6OZC1Av0imB Rw56+Yk504T02wt5+YudQooTjHl27r0mwCVId0Rb8jqKOoGbbgHkB651Pm6eWFEypVvG i+zA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1761019656; x=1761624456; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=XKYICs2FgVs0B/gNsszFx1e+o/+DAZGMx0FA5uzNqFs=; b=wxUZQ3gQztWH3R38J2IKjKLMtzXi8PoI3/AnH6qoVVcxma77BVB3qthKGqz+dNKyBC OLl/kYxBHi4Yn4dnqQbbjF22uCF9hcwZnLrsBcziG+LBfeoyApm/UP/Q4+vKOMt6jBJx 2BGyDCwXDTn8HXQ0g/XJY/KSpKRnkX9ovjpIJzxPl0XtOJz0bok8L8yM/5FIAS7AmDGl 55SBafp64AbPYhR0xApotAdqjcNW1gWfD0JOwspgBZtDKoxNiYwYzVqjXzMmuYC0fw89 DaRwmF6vI6Y4MdaXlXK81kKQBy0Zr12dfqKGWtKnjeJ+btcWl/3FIo53WO+9lQFqi4T7 lXmA== X-Gm-Message-State: AOJu0Yw4TIsZ3vLjAHPu1lwLjEibxaPN0yCt3hie0gt1MSouiFv/ZDJx fh9MHsL/5S3kreYvPE7ihrc1OljVoyyWjlYL7YvfAjxeI2QBhuPL4TkmRjkWSGcBaR09CexEo2z zduISnqWkXXLpZj6nwsJCD3gUxWJG1DhsW471 X-Gm-Gg: ASbGnctnBpiQrJAA77ox8jJOe1uHciOP57f4e4OoUILT3YbhA8s4QtOCT8WicIGA2Bo rqdKY7IHqykFo5EY0mzNV4Zg+/DCgqp0FcJOQPUVn3VSDGh3VfTjOAm7Kezc3o6jauF7SyVCjCK yG/ULWOqwJV4UgAkKfrxhKo6f/8LAIXzph3Na/7427j/LbziW0c2mFd90CbbsulzZq4+xINQWvH Y9K3Lv13eWR7PQaUxN4IVRZ5nOM4m1BZJ/ZiUbn2O4Lrc6zb8eVlt8ImQY4HA== X-Google-Smtp-Source: AGHT+IG5Vbha4yow3bK12J0Q5Dj+raYkyWs2Nq5b4qZUgbwDcyDQ/7ukX8YXFDoYZYz3MBmxq54GaJ9vcnYxmRXBWoI= X-Received: by 2002:a17:90b:2e47:b0:32d:a37c:4e31 with SMTP id 98e67ed59e1d1-33b9e2a69a6mr25016450a91.17.1761019655888; Mon, 20 Oct 2025 21:07:35 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Amit Langote Date: Tue, 21 Oct 2025 13:07:19 +0900 X-Gm-Features: AS18NWApZN2CyDPewyuTiNclbYNLQgL9YNDuufEMVzjJW4GtCFYpanwcCoR-LGQ Message-ID: Subject: Re: Eliminating SPI / SQL from some RI triggers - take 3 To: PostgreSQL-development Cc: Junwang Zhao Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Apr 3, 2025 at 7:19=E2=80=AFPM Amit Langote wrote: > On Fri, Dec 20, 2024 at 1:23=E2=80=AFPM Amit Langote wrote: > > We discussed $subject at [1] and [2] and I'd like to continue that > > work with the hope to commit some part of it for v18. > > I did not get a chance to do any further work on this in this cycle, > but plan to start working on it after beta release, so moving this to > the next CF. I will post a rebased patch after the freeze to keep the > bots green for now. Sorry for the inactivity. I've moved the patch entry in the CF app to PG19-Drafts, since I don't plan to work on it myself in the immediate future. However, Junwang Zhao has expressed interest in taking this work forward, and I look forward to working with him on it. --=20 Thanks, Amit Langote