From: Tom Lane <tgl@sss.pgh.pa.us>
To: ariel@mashraki.co.il
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18117: View definitions were changed in version 16 (missing column qualifiers)
Date: Wed, 20 Sep 2023 10:20:12 -0400
Message-ID: <523986.1695219612@sss.pgh.pa.us> (raw)
In-Reply-To: <18117-972f125de280aa93@postgresql.org>
References: <18117-972f125de280aa93@postgresql.org>
PG Bug reporting form <noreply@postgresql.org> writes:
> 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';
Yeah, that was intentional, cf
https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=47bb9db75
I don't see any corresponding entry in the v16 release notes,
but it doesn't surprise me that Bruce would have deemed this
an internal change not worth documenting. Minor cosmetic
changes in the output of view deparsing are very common.
regards, tom lane
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: tgl@sss.pgh.pa.us, ariel@mashraki.co.il, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18117: View definitions were changed in version 16 (missing column qualifiers)
In-Reply-To: <523986.1695219612@sss.pgh.pa.us>
* 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