Re: Fixes for missing schema qualifications

Michael Paquier <michael@paquier.xyz>

From: Michael Paquier <michael@paquier.xyz>
To: Noah Misch <noah@leadboat.com>
Cc: Postgres hackers <pgsql-hackers@postgresql.org>
Date: 2018-11-29T07:20:24Z
Lists: pgsql-hackers
On Fri, Mar 16, 2018 at 10:18:59AM +0900, Michael Paquier wrote:
> So based on the feedback here is what we could at least do now as a
> minimal fix set, in the shape of:
> - Patch functions in information_schema.sql, using either operator() or
> SET search_path.
> - Patch function qualifications I found here and there.  Those are
> mainly one-liners, and gives readers better references for their own
> queries.

From what I can see in my backlog, this never actually got into the
tree, and it seems to me that fixing those issues is always better than
nothing:
https://www.postgresql.org/message-id/20180309075538.GD9376@paquier.xyz

Any thoughts?  This does not reinvent the wheel..
--
Michael

Commits

  1. Add some missing schema qualifications