| From: | Kirill Reshke <reshkekirill(at)gmail(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alexander Lakhin <exclusion(at)gmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Justin Pryzby <pryzby(at)telsasoft(dot)com> |
| Subject: | Re: Internal error codes triggered by regression tests and user queries, take 2 |
| Date: | 2026-11-12 11:34:37 |
| Message-ID: | CALdSSPjG0n6BFkbbyYeYsaArEOXnDrqEiQAzXrhM3cFzy1ztxQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, 12 Nov 2026 at 15:29, Kirill Reshke <reshkekirill(at)gmail(dot)com> wrote:
>
>
> Another case
>
> begin;
> create type tt AS (a int, b int);
> prepare x as SELECT (i, 1)::tt FROM generate_series(1,1) i;
> rollback ;
> execute x;
> --- ERROR: cache lookup failed for type 16487
>
> found by looking into
> https://git.postgresql.org/cgit/postgresql.git/commit/?id=0b0f5c5af11b868c15ae2f80010e351f04a6b2e5
Looks like typed constants/row expressions reference a user-def type
without plan invalidation machinery. Attached uses
record_plan_type_dependency to fix that
--
Best regards,
Kirill Reshke
| Attachment | Content-Type | Size |
|---|---|---|
| v2-code-only.diff | application/octet-stream | 866 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | JoongHyuk Shin | 2026-11-12 11:58:20 | Re: [PATCH] Add recovery boundary WAL record for database and tablespace commands |
| Previous Message | Heikki Linnakangas | 2026-11-12 11:16:53 | SIGFPE handling |