public inbox for [email protected]  

help / color / mirror / Atom feed

Error creating materialized view
2+ messages / 2 participants
[nested] [flat]

* Error creating materialized view
@ 2024-11-25 06:08 Shaun Robinson <[email protected]>
  2024-11-25 12:54 ` Re: Error creating materialized view Laurenz Albe <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Shaun Robinson @ 2024-11-25 06:08 UTC (permalink / raw)
  To: [email protected]

Hi,

I'm currently testing an application with Postgres 17.2 and am getting an
error when creating a materialized view which works in version 16 and
below. The sql works fine running as a query, but adding the
create materialized view breaks it.

The error comes when calling a custom function and the error is that a
relation doesn't exist (which it does as it works within the same query
when not creating a view).

Is this a known issue in the version 17.2?

Thanks
Shaun


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Error creating materialized view
  2024-11-25 06:08 Error creating materialized view Shaun Robinson <[email protected]>
@ 2024-11-25 12:54 ` Laurenz Albe <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Laurenz Albe @ 2024-11-25 12:54 UTC (permalink / raw)
  To: Shaun Robinson <[email protected]>; [email protected]

On Mon, 2024-11-25 at 06:08 +0000, Shaun Robinson wrote:
> I'm currently testing an application with Postgres 17.2 and am getting an error
> when creating a materialized view which works in version 16 and below. The sql
> works fine running as a query, but adding the create materialized view breaks it.
> 
> The error comes when calling a custom function and the error is that a relation
> doesn't exist (which it does as it works within the same query when not creating
> a view).
> 
> Is this a known issue in the version 17.2?

That's a deliberate improvemen; see the first point in
https://www.postgresql.org/docs/current/release-17.html#RELEASE-17-MIGRATION

you will have to schema-qualify all tables in the function or set the
"search_path" on the function.

Yours,
Laurenz Albe






^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2024-11-25 12:54 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-11-25 06:08 Error creating materialized view Shaun Robinson <[email protected]>
2024-11-25 12:54 ` Laurenz Albe <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox