Re: BUG #18929: After the view is created, executed query against the view definition, reported syntax error. - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: BUG #18929: After the view is created, executed query against the view definition, reported syntax error.
Date
Msg-id aCwM3RSlrD2mk1mT@paquier.xyz
Whole thread Raw
In response to BUG #18929: After the view is created, executed query against the view definition, reported syntax error.  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #18929: After the view is created, executed query against the view definition, reported syntax error.
List 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

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG #18929: After the view is created, executed query against the view definition, reported syntax error.
Next
From: Laurenz Albe
Date:
Subject: Re: BUG #18934: Even with WITH ADMIN OPTION, I Cannot Manage Role Memberships