Re: Fixes for missing schema qualifications

Noah Misch wrote:
> On Fri, Mar 09, 2018 at 04:55:38PM +0900, Michael Paquier wrote:
> > --- a/src/backend/catalog/information_schema.sql
> > +++ b/src/backend/catalog/information_schema.sql
> > @@ -186,7 +186,7 @@ CREATE FUNCTION _pg_interval_type(typid oid, mod int4) RETURNS text
> > AS
> > $$SELECT
> > CASE WHEN $1 IN (1186) /* interval */
> > - THEN upper(substring(format_type($1, $2) from 'interval[()0-9]* #"%#"' for '#'))
> > + THEN pg_catalog.upper(substring(pg_catalog.format_type($1, $2) from 'interval[()0-9]* #"%#"' for '#'))
> > ELSE null
> > END$$;

> This qualifies some functions, but it leaves plenty of unqualified operators.

... and substring() ...

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services