On 10/15/2017 18:27, Tom Lane wrote:
Karl Denninger <karl@denninger.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)