Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux