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

From Heikki Linnakangas
Subject Re: BUG #18929: After the view is created, executed query against the view definition, reported syntax error.
Date
Msg-id 41c94ff6-e6c8-4844-a67d-e5fd545f457f@iki.fi
Whole thread Raw
In response to Re: BUG #18929: After the view is created, executed query against the view definition, reported syntax error.  (Michael Paquier <michael@paquier.xyz>)
Responses Re: BUG #18929: After the view is created, executed query against the view definition, reported syntax error.
List pgsql-bugs
On 20/05/2025 08:02, Michael Paquier wrote:
> 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.

Committed the same fix.  Sorry for not crediting you in the commit 
message, I reached the same conclusion and committed before I saw this 
discussion. Thanks for looking!

-- 
Heikki Linnakangas
Neon (https://neon.tech)



pgsql-bugs by date:

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