From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: zeograd@gmail.com
Subject: BUG #18813: Materialized view creation regression when inlining recursive SQL function
Date: Sun, 16 Feb 2025 15:49:55 +0000
Message-ID: <18813-d5dadfa976a8ee2e@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18813
Logged by: Olivier Jolly
Email address: zeograd@gmail.com
PostgreSQL version: 17.3
Operating system: Debian 12.2 (official docker images)
Description:
Hi,
I've encountered an error when creating a materialized view as I updated
its body by introducing a recursive function.
On postgreSQL 16, it works as expected: the materialized view is created and
works as intended.
Starting from posgreSQL 17.0, the materialized view created failed with the
error message
ERROR: function jsonb_recursive_merge(jsonb, jsonb) does not exist
LINE 9: ELSE jsonb_recursive_merge(va::jsonb, vb:...
^
HINT: No function matches the given name and argument types. You might need
to add explicit type casts.
CONTEXT: SQL function "jsonb_recursive_merge" during inlining
postgreSQL 17.3 also returns the same error.
A somewhat minimal .sql script triggering the error (as well as reproducible
CLI invocations and results from the execution in 16.7, 17.0 and 17.3
official docker images) is available on
https://gitlab.com/-/snippets/4807302
I would expect that postgreSQL 17.x allows creating my materialized view
like it did in postgreSQL 16.7
Thanks in advance for your help,
Olivier
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, zeograd@gmail.com
Subject: Re: BUG #18813: Materialized view creation regression when inlining recursive SQL function
In-Reply-To: <18813-d5dadfa976a8ee2e@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox