"Markus Wollny" <[EMAIL PROTECTED]> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general