Re: tsvector_update_trigger throws error "column is not of tsvector type" - Mailing list 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
thesystem 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