Re: Tsearch2 removal bit me - how to correct?

On 10/15/2017 18:42, Karl Denninger wrote:
> 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)
>
One more question - for safety do I also need to drop all the other
previously-declared public functions such as rank*() (in all its forms)
and concat even thought they do not reference the shared library, or are
they safe to leave there?  I see there are pg_catalog copies of these as
well....

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