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

From: "Markus Wollny" <Markus(dot)Wollny(at)computec(dot)de>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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:42:18
Message-ID: 28011CD60FB1724DBA4442E38277F62608C5AF2C@hermes.computec.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Kind regards

Markus

Computec Media AG
Sitz der Gesellschaft und Registergericht: Fürth (HRB 8818)
Vorstandsmitglieder: Johannes S. Gözalan (Vorsitzender) und Rainer Rosenbusch
Vorsitzender des Aufsichtsrates: Jürg Marquard
Umsatzsteuer-Identifikationsnummer: DE 812 575 276

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Syra.Didelez 2008-04-09 14:55:42 Re: Problem with windows Postgres 8.3.1 MSI binary distribution
Previous Message Stefan Schwarzer 2008-04-09 14:41:25 Dump/Transfer Sequence Problems