Re: SQL:2011 Application Time Update & Delete

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter(at)eisentraut(dot)org>
Cc: Paul A Jungwirth <pj(at)illuminatedcomputing(dot)com>, Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: SQL:2011 Application Time Update & Delete
Date: 2026-04-19 18:10:02
Message-ID: 4126231.1776622202@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Peter Eisentraut <peter(at)eisentraut(dot)org> writes:
> I have committed the patches 0001 through 0003.

Coverity is complaining that rsi.isDone may be used uninitialized in
ExecForPortionOfLeftovers. It's correct: that function is not obeying
the function call protocol, and it's only accidental that it's not
failing. In ValuePerCall mode the caller is supposed to initialize
isDone (and isnull too) before each call. The canonical reference
for this is execSRF.c, and it does that. So I think we need something
like the attached.

I notice that execSRF.c also runs pgstat_init_function_usage and
pgstat_end_function_usage around each call. That's not too important
right now, but I wonder whether we should add it while we're looking
at this. It would perhaps be important once we support user-defined
withoutPortionProcs.

regards, tom lane

Attachment Content-Type Size
v1-make-ExecForPortionOfLeftovers-obey-protocol.patch text/x-diff 1.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2026-04-19 18:36:57 Re: First draft of PG 19 release notes
Previous Message Paul A Jungwirth 2026-04-19 18:07:47 Re: DELETE/UPDATE FOR PORTION OF with rule system is not working