From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: ariel@mashraki.co.il
Subject: BUG #18117: View definitions were changed in version 16 (missing column qualifiers)
Date: Wed, 20 Sep 2023 09:08:31 +0000
Message-ID: <18117-972f125de280aa93@postgresql.org> (raw)
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;
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: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, ariel@mashraki.co.il
Subject: Re: BUG #18117: View definitions were changed in version 16 (missing column qualifiers)
In-Reply-To: <18117-972f125de280aa93@postgresql.org>
* 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