Re: BUG #18929: After the view is created, executed query against the view definition, reported syntax error.

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, 707330139(at)qq(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #18929: After the view is created, executed query against the view definition, reported syntax error.
Date: 2025-05-20 05:02:21
Message-ID: aCwM3RSlrD2mk1mT@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, May 20, 2025 at 12:31:26AM -0400, Tom Lane wrote:
> In the no-good-deed-goes-unpunished department: it appears from
> buildfarm reports that we need to do something about output
> mismatches in cross-version-upgrade tests due to this commit.
> I didn't yet look more closely.

Yes, the buildfarm is unhappy.

It seems to me that this needs an update of @_unused_view_qualifiers
in AdjustUpgrade.pm to update public.limit_thousand_v_5's qual, like
in the attached. This is needed in v16 and newer branches.
--
Michael

Attachment Content-Type Size
fix-upgrade-test.patch text/x-diff 646 bytes

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Laurenz Albe 2025-05-20 06:40:15 Re: BUG #18934: Even with WITH ADMIN OPTION, I Cannot Manage Role Memberships
Previous Message Tom Lane 2025-05-20 04:31:26 Re: BUG #18929: After the view is created, executed query against the view definition, reported syntax error.