Re: to_tsvector() chopping off trailing 's' characters

Yeah, odd. I must have borked this somehow, probably remnants of an older
installation. I have two PG 12 servers, one where 'simple' works, which has:

Schema | Name | Result data type | Argument data types | Type
------------+-------------+------------------+---------------------+------
pg_catalog | to_tsvector | tsvector | json | func
pg_catalog | to_tsvector | tsvector | jsonb | func
pg_catalog | to_tsvector | tsvector | regconfig, json | func
pg_catalog | to_tsvector | tsvector | regconfig, jsonb | func
pg_catalog | to_tsvector | tsvector | regconfig, text | func
pg_catalog | to_tsvector | tsvector | text | func

And the one where it's borked:

Schema | Name | Result data type | Argument data types | Type
------------+-------------+------------------+---------------------+------
pg_catalog | to_tsvector | tsvector | json | func
pg_catalog | to_tsvector | tsvector | jsonb | func
pg_catalog | to_tsvector | tsvector | regconfig, json | func
pg_catalog | to_tsvector | tsvector | regconfig, jsonb | func
pg_catalog | to_tsvector | tsvector | regconfig, text | func
pg_catalog | to_tsvector | tsvector | text | func
public | to_tsvector | tsvector | oid, text | func

Seems that public function is the weirdo remnant breaking things. I ...
think... I can just drop public.to_tsvector, right?

On Fri, Nov 1, 2019 at 11:54 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Wells Oliver <wells(dot)oliver(at)gmail(dot)com> writes:
> > Sorry for the follow up, meant to add I tried this:
> > select 'Thames', to_tsvector('simple', 'fat cats ate rats');
> > And it throws: ERROR: invalid input syntax for type oid: "simple"
>
> That works for me. I suspect you've got some nonstandard versions
> of to_tsvector() hanging about. There should only be
>
> regression=# \df to_tsvector
> List of functions
> Schema | Name | Result data type | Argument data types | Type
> ------------+-------------+------------------+---------------------+------
> pg_catalog | to_tsvector | tsvector | json | func
> pg_catalog | to_tsvector | tsvector | jsonb | func
> pg_catalog | to_tsvector | tsvector | regconfig, json | func
> pg_catalog | to_tsvector | tsvector | regconfig, jsonb | func
> pg_catalog | to_tsvector | tsvector | regconfig, text | func
> pg_catalog | to_tsvector | tsvector | text | func
> (6 rows)
>
> regards, tom lane
>

--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>