Re: Fixes for missing schema qualifications

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Noah Misch <noah(at)leadboat(dot)com>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, Postgres hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fixes for missing schema qualifications
Date: 2018-03-10 18:13:09
Message-ID: 20180310181309.k54cdkkw4hccurkq@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message legrand legrand 2018-03-10 18:32:35 Re: All Taxi Services need Index Clustered Heap Append
Previous Message Alvaro Herrera 2018-03-10 18:02:27 Re: FOR EACH ROW triggers on partitioned tables