From: Tom Lane <tgl@sss.pgh.pa.us>
To: Wells Oliver <wells.oliver@gmail.com>
cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: to_tsvector() chopping off trailing 's' characters
In-reply-to: 
 <CAOC+FBWByhjrZTR7st1nfzqQ7g+yvjtB29oScpFAuMy398eJaQ@mail.gmail.com>
References: 
 <CAOC+FBWAsQy7Gb57xqx8NVo3A5xq_zdrF6FuXXZ_AgmiSfMBeQ@mail.gmail.com>
 <CAOC+FBWByhjrZTR7st1nfzqQ7g+yvjtB29oScpFAuMy398eJaQ@mail.gmail.com>
Comments: In-reply-to Wells Oliver <wells.oliver@gmail.com>
	message dated "Fri, 01 Nov 2019 11:35:27 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <31421.1572634457.1@sss.pgh.pa.us>
Date: Fri, 01 Nov 2019 14:54:17 -0400
Message-ID: <31422.1572634457@sss.pgh.pa.us>
Precedence: bulk

Wells Oliver <wells.oliver@gmail.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