Re: Fixes for missing schema qualifications

From: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
To: noah(at)leadboat(dot)com
Cc: michael(at)paquier(dot)xyz, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Fixes for missing schema qualifications
Date: 2018-03-14 00:08:59
Message-ID: 20180314.090859.995721754411314761.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>> + "select pg_catalog.count(*) "
>> + "from pg_catalog.pg_namespace where nspname = '%s'",
>
> This qualifies some functions, but it leaves plenty of unqualified operators.

So this should go something like this?

select pg_catalog.count(*) from pg_catalog.pg_namespace where nameeq(nspname, '%s');

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2018-03-14 00:11:53 Re: Fixes for missing schema qualifications
Previous Message Oleg Bartunov 2018-03-14 00:08:17 Re: SQL/JSON: functions