Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #18642: Creating a materialized view on top of ts_stat succeeds on 16.4, but it fails on 17.0 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #18642: Creating a materialized view on top of ts_stat succeeds on 16.4, but it fails on 17.0
Date
Msg-id 1450084.1727704844@sss.pgh.pa.us
Whole thread Raw
In response to BUG #18642: Creating a materialized view on top of ts_stat succeeds on 16.4, but it fails on 17.0  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
Tree view 
PG Bug reporting form <noreply@postgresql.org> writes:
> On PostgreSQL16 one can create a materialized view using ts_stat, but it
> breaks on PostgreSQL17 due to no finding the table from the ts_stat query
> (while the table does exist), please see below a test example.

This is expected: you'll need to qualify the table name.  See the
very first compatibility entry in the v17 release notes.

            regards, tom lane

pgsql-bugs by date:

Previous
From: semab tariq
Date:
Subject: Re: what are the things that occupy the session memory.
Next
From: Amit Kapila
Date:
Subject: Re: BUG #18641: Logical decoding of two-phase commit fails with TOASTed default values