Re: ERREUR: cache lookup failed for function 0 with PostgreSQL 15 beta 2, no error with PostgreSQL 14.4 - Mailing list pgsql-hackers

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