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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: petrica(dot)leuca(at)gmail(dot)com
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #18642: Creating a materialized view on top of ts_stat succeeds on 16.4, but it fails on 17.0
Date: 2024-09-30 14:00:44
Message-ID: 1450084.1727704844@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PG Bug reporting form <noreply(at)postgresql(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Amit Kapila 2024-09-30 16:20:00 Re: BUG #18641: Logical decoding of two-phase commit fails with TOASTed default values
Previous Message semab tariq 2024-09-30 13:49:07 Re: what are the things that occupy the session memory.