Re: Tsearch2 removal bit me - how to correct?

On 10/15/2017 18:27, Tom Lane wrote:
> Karl Denninger <karl(at)denninger(dot)net> writes:
>> ticker=# select to_tsvector('english', 'in the list of stop words');
>> ERROR:  invalid input syntax for type oid: "english"
> WFM. I think you didn't get rid of the tsearch2 version of
> to_tsvector in that database, as that version would take a plain
> OID argument not regconfig.
>
> regards, tom lane
I think I found most of the problems (it's working now on the internal
functions and I was able to recreate the indices) EXCEPT that I still
have references to tsearch2 in pg_proc, which means it won't upgrade,
and they're in the system catalog so I can't drop the functions either.

ticker=# select proname from pg_proc where probin like '%tsearch2%';
    proname
----------------
 prsd_end
 prsd_lextype
 prsd_start
 thesaurus_init
(4 rows)

ticker=# \df prsd_end;
                            List of functions
   Schema   |   Name   | Result data type | Argument data types |  Type
------------+----------+------------------+---------------------+--------
 pg_catalog | prsd_end | void             | internal            | normal
(1 row)

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