From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Peter Wright <pete@flooble.net>
To: pgsql-bugs@lists.postgresql.org
Subject: Re: Unqualified name not resolved in function called from materialized view (17.4)
Date: Tue, 11 Mar 2025 12:58:37 +0100
Message-ID: <df50dda5bad084ae0e8d8a8077d015a86625396a.camel@cybertec.at> (raw)
In-Reply-To: <Z8_4Lf5EKH4ZDwvg@flooble.net>
References: <Z8_4Lf5EKH4ZDwvg@flooble.net>
On Tue, 2025-03-11 at 19:45 +1100, Peter Wright wrote:
> PostgreSQL version: 17.4
> Operating system: Ubuntu 24.04, x86_64, kernel 6.8.0-51-generic
> Description:
>
> Given a file "break_it.sql" containing this SQL:
>
> SELECT version();
> CREATE VIEW things AS SELECT 1 AS id, 'rock' AS thing_name;
> CREATE FUNCTION num_things() RETURNS INTEGER AS $$ SELECT COUNT(1) FROM things; $$ LANGUAGE SQL STABLE;
> CREATE MATERIALIZED VIEW thing_report AS SELECT num_things() AS number_of_things;
>
> Running the following commands with the environment pointing at a PostgreSQL 17.4 server:
>
> psql:break_it.sql:4: ERROR: relation "things" does not exist
> LINE 1: SELECT COUNT(1) FROM things;
> ^
> QUERY: SELECT COUNT(1) FROM things;
> CONTEXT: SQL function "num_things" during inlining
>
>
> Running the same commands with the environment pointing at a PostgreSQL 16.8
> server does *not* report an error
That is not a bug, it is intentional.
See the first entry in the list of incompatibilities
https://www.postgresql.org/docs/current/release-17.html#RELEASE-17-MIGRATION
You should fix the function.
Yours,
Laurenz Albe
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: laurenz.albe@cybertec.at, pete@flooble.net, pgsql-bugs@lists.postgresql.org
Subject: Re: Unqualified name not resolved in function called from materialized view (17.4)
In-Reply-To: <df50dda5bad084ae0e8d8a8077d015a86625396a.camel@cybertec.at>
* 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