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 15:39:34
Message-ID: 20674.1207755574@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:
> Tom Lane wrote:
>> 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.)

> Which would probably be not such a good idea to try on a 7GB table in production, I think. Or is there some way hacking the system catalog to correct the type instead of an ALTER TABLE ... ALTER COLUMN TYPE?

Well, you could probably get away with an "update pg_attribute set
atttypid ..." but it might be safer to just wait for 8.3.2.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Syra.Didelez 2008-04-09 15:39:42 Re: Problem with windows Postgres 8.3.1 MSI binary distribution
Previous Message Martin Gainty 2008-04-09 15:32:18 Re: Problem with windows Postgres 8.3.1 MSI binary distribution