Re: Tsearch2 removal bit me - how to correct?

[Karl Denninger <karl@xxxxxxxxxxxxx>]

On 10/15/2017 18:27, Tom Lane wrote:

Karl Denninger <karl@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxx
The Market Ticker
[S/MIME encrypted email preferred]

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature