Re: Tsearch2 removal bit me - how to correct?

On 10/15/2017 18:25, Tom Lane wrote:
> Karl Denninger <karl(at)denninger(dot)net> writes:
>> That worked on one of my clusters, but on another I'm seeing entries in
>> pg_catalog, and can't remove them.
>> pgsql=# \c fapforum
>> You are now connected to database "fapforum" as user "pgsql".
>> fapforum=# select proname from pg_proc where probin like '%tsearch2%';
>>     proname
>> ----------------
>>  prsd_end
>>  prsd_lextype
>>  prsd_start
>>  thesaurus_init
>> (4 rows)
> There *should* be a pg_catalog.prsd_end built-in function, but it's
> going to have null probin. I think you're being careless about
> schema names here.
>
>> fapforum=# \df prsd_end;
>>                             List of functions
>>    Schema   |   Name   | Result data type | Argument data types |  Type
>> ------------+----------+------------------+---------------------+--------
>>  pg_catalog | prsd_end | void             | internal            | normal
>> (1 row)
> This does not prove that there's not a, say, public.prsd_end. Try
> "\df *.prsd_end" to see all the functions by that name.
>
> regards, tom lane
You are correct.  Thanks; got it.  (That's what I get for not being
specific)

--
Karl Denninger
karl(at)denninger(dot)net <mailto:karl(at)denninger(dot)net>
/The Market Ticker/
/[S/MIME encrypted email preferred]/