Re: BUG #19493: Assertion failure in pg_plan_advice with EXISTS subquery and DO_NOT_SCAN advice

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Калинин Никита <n.kalinin@postgrespro.ru>
Cc: Michael Paquier <michael@paquier.xyz>, pgsql-bugs@lists.postgresql.org, Pierre Forstmann <pierre.forstmann@gmail.com>
Date: 2026-05-27T01:08:19Z
Lists: pgsql-bugs
=?UTF-8?B?0JrQsNC70LjQvdC40L0g0J3QuNC60LjRgtCw?= <n.kalinin@postgrespro.ru> writes:
> Could this be related to GCC? I'm using GCC 16.1.1 and I can reproduce the crash with that version.

Maybe.  Does it still fail if you set the optimization level to -O0 ?

			regards, tom lane



Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →
  1. pg_plan_advice: DO_NOT_SCAN is a simple tag, not a generic one.

  2. doc: add comma to UPDATE docs, for consistency

  3. Add stack depth check to QueueFKConstraintValidation().