Re: tsvector_update_trigger throws error "column is not of tsvector type"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Markus Wollny" <Markus(dot)Wollny(at)computec(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: tsvector_update_trigger throws error "column is not of tsvector type"
Date: 2008-04-09 14:01:52
Message-ID: 19324.1207749712@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Markus Wollny" <Markus(dot)Wollny(at)computec(dot)de> writes:
> Everything works fine. It's sort of less elegant though than having just the one generic trigger function and configuring the 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kyle Wilcox 2008-04-09 14:04:19 Re: Trouble with foreign key
Previous Message Hardwick, Joe 2008-04-09 13:52:03 Crash after VACUUM FULL cancel