Bruce Momjian wrote:
> Tom Lane wrote:
> > 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
Uh, isn't pg_migrator itself a large-caliber foot gun? No need to call
just part of it a foot gun. ;-)
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +