Re: tsvector_update_trigger throws error "column is not of tsvector type" - Mailing list pgsql-general

From Tom Lane
Subject Re: tsvector_update_trigger throws error "column is not of tsvector type"
Date
Msg-id 19324.1207749712@sss.pgh.pa.us
Whole thread Raw
In response to Re: tsvector_update_trigger throws error "column is not of tsvector type"  ("Markus Wollny" <Markus.Wollny@computec.de>)
Responses Re: tsvector_update_trigger throws error "column is not of tsvector type"  ("Markus Wollny" <Markus.Wollny@computec.de>)
List pgsql-general
"Markus Wollny" <Markus.Wollny@computec.de> writes:
> Everything works fine. It's sort of less elegant though than having just the one generic trigger function and
configuringthe needed fields in the trigger itself.  

It should work if you explicitly change the column's type to
pg_catalog.tsvector.  (There's a fix in place for 8.3.2, also.)

            regards, tom lane

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Cannot use a standalone backend to VACUUM in "postgres""
Next
From: Kyle Wilcox
Date:
Subject: Re: Trouble with foreign key