Re: [GENERAL] 9.5: tsvector problem

2016-04-26 Thread Johann Spies
On 26 April 2016 at 15:35, Charles Clavadetscher wrote: > Hello Johann > > There are two to_tsvector functions: > > charles@charles.[local]=# \df to_tsvector > List of functions >Schema |Name | Result data type | Argument data types | Type > > --

Re: [GENERAL] 9.5: tsvector problem

2016-04-26 Thread Charles Clavadetscher
Hello Johann There are two to_tsvector functions: charles@charles.[local]=# \df to_tsvector List of functions Schema |Name | Result data type | Argument data types | Type +-+--+-+ pg_

[GENERAL] 9.5: tsvector problem

2016-04-26 Thread Johann Spies
I have never seen this problem before. It occurred while trying to import a dump (done by 9.5 client of a 9.4 database) also. Table definition: - CREATE TABLE source.annual ( filename text, gzipfile text, id serial NOT NULL, tsv tsvector, ut character varying(19), xml xml, processe