Re: SQL:2011 Application Time Update & Delete - Mailing list pgsql-hackers

Paul A Jungwirth <pj@illuminatedcomputing.com> writes:
> On Mon, Apr 20, 2026 at 7:33 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> But speaking of infinite loops, should this one contain a
>> CHECK_FOR_INTERRUPTS call?  It's hard to conceive of a case where
>> the value would be broken down finely enough for that to be a
>> problem, but ...

> A rangetype could only loop 0-2 times; a multirange 0-1. So I don't
> think we need it. Eventually user-defined types could loop more, but a
> design that inserts many records every time you change something seems
> like a bad idea. Maybe I would add it anyway just out of caution, but
> I suspect it's excessive.

Fair enough.  It's quite likely that we'd hit at least one CFI down
inside the insertion anyway.

            regards, tom lane