Re: pg_migrator and an 8.3-compatible tsvector data type - Mailing list pgsql-hackers

Bruce Momjian <bruce@momjian.us> writes:
> I have discovered a simpler solution using ALTER TABLE and calling a
> conversion function:

>     test=> CREATE TABLE tsvector_test(x tsvector);
>     CREATE TABLE
>     test=> ALTER TABLE tsvector_test ALTER COLUMN x TYPE tsvector 
>     test-> USING conversion_func(x);
>     ALTER TABLE

> No need for a fake data type and the required index infrastructure.

I think this is basically a large-caliber foot gun.  You're going to
pretend that invalid data is valid, until the user gets around to fixing
it?
        regards, tom lane