Re: BUG #19638: Planner chooses an index-only scan for an index AM without amcanreturn, and execution fails

From: Andrey Rachitskiy <pl0h0yp1(at)gmail(dot)com>
To: Manuel Reyes Bravo <manuelreyesbravo(at)gmail(dot)com>
Cc: David Rowley <dgrowleyml(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19638: Planner chooses an index-only scan for an index AM without amcanreturn, and execution fails
Date: 2026-08-24 19:34:38
Message-ID: CAB8bMit+uS_sdXTa_8eqRJwN-K3LcaCJNoADz5ZHOdSwe_h3Nw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

пн, 24 авг. 2026 г. в 23:52, Manuel Reyes Bravo <manuelreyesbravo(at)gmail(dot)com
>:
unpatched: Aggregate -> Index Only Scan using i_expr on t_expr
patched: Aggregate -> Seq Scan on t_expr (disabled)

Agreed, v3 fixed this.

--
Regards,
Rachitskiy Andrey

Attachment Content-Type Size
v3-0002-Reject-index-only-scans-when-index-cannot-return.patch text/x-patch 2.6 KB

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bharath Rupireddy 2026-08-24 19:42:00 Re: autovacuum: automatically propagate updated parameters
Previous Message Manuel Reyes Bravo 2026-08-24 18:52:42 Re: BUG #19638: Planner chooses an index-only scan for an index AM without amcanreturn, and execution fails