Horton

Re: ERREUR: cache lookup failed for function 0 with PostgreSQL 15 beta 2, no error with PostgreSQL 14.4

David Rowley <dgrowleyml@gmail.com>

View thread
From: David Rowley <dgrowleyml@gmail.com>
To: Phil Florent <philflorent@hotmail.com>
Cc: "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>
Date: 2022-08-04T22:21:11Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Fix failure to set correct operator in window run condition

  2. Teach planner and executor about monotonic window funcs

On Fri, 5 Aug 2022 at 01:20, Phil Florent <philflorent@hotmail.com> wrote:
> with fakedata as (
>                select 'hello' word
>                union all
>                select 'world' word
> )
> select *
> from (
>                select word, count(*) over (partition by word) nb from fakedata
> ) t where nb = 1;
> ERREUR:  cache lookup failed for function 0

> A DSS developer from my company, Julien Roze, reported me an error I cannot explained. Is it a new behavior or a bug ?

Thank you for the report and the minimal self-contained test case.
That's highly useful for us.

I've now committed a fix for this ([1]).  It will appear in the next
beta release for PG15.

David

[1] https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=270eb4b5d4986534f2d522ebb19f67396d13cf44