BUG #18117: View definitions were changed in version 16 (missing column qualifiers) - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #18117: View definitions were changed in version 16 (missing column qualifiers)
Date
Msg-id 18117-972f125de280aa93@postgresql.org
Whole thread Raw
Responses Re: BUG #18117: View definitions were changed in version 16 (missing column qualifiers)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      18117
Logged by:          Ariel Mashraki
Email address:      ariel@mashraki.co.il
PostgreSQL version: 16.0
Operating system:   Mac
Description:

I'm not sure if this change was intentional since it wasn't mentioned in the
release notes, or at least, I couldn't find it there. Running the three
statements below in version 16 produces ~different results from those in all
versions before 16. I checked this against versions 11, 12, ... 15

Statements:
create table t(c int);
create view v(c) as select c from t;
select view_definition from information_schema.views where table_name='v';

Result in previous versions:
SELECT t.c FROM t;

Result in the latest version:
SELECT c FROM t;


pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #18112: pgstattuple of sequence failed
Next
From: PG Bug reporting form
Date:
Subject: BUG #18118: bug report for COMMIT AND CHAIN feature