Skip site navigation (1) Skip section navigation (2)

Re: pg_migrator and an 8.3-compatible tsvector data type

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Josh Berkus <josh(at)agliodbs(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, Teodor Sigaev <teodor(at)sigaev(dot)ru>
Subject: Re: pg_migrator and an 8.3-compatible tsvector data type
Date: 2009-05-31 14:04:29
Message-ID: 200905311404.n4VE4TT27860@momjian.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Bruce Momjian wrote:
> Tom Lane wrote:
> > Bruce Momjian <bruce(at)momjian(dot)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?
> 
> What choice do we have?  While we can mark indexes as invalid (which we
> do), how do we mark a table's contents as invalid?  Should we create
> rules so no one can see the data and then have the ALTER TABLE script
> remove the rules after it is rebuilt?

OK, what ideas do people have to prevent access to tsvector columns?  I
am thinking of renaming the tables or something.

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

Responses

pgsql-hackers by date

Next:From: Greg StarkDate: 2009-05-31 14:30:09
Subject: Re: pg_migrator and an 8.3-compatible tsvector data type
Previous:From: Bruce MomjianDate: 2009-05-31 13:47:21
Subject: Re: pg_migrator and an 8.3-compatible tsvector data type

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group