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 20:13:26
Message-ID: 200905312013.n4VKDQQ12806@momjian.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Bruce Momjian wrote:
> 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.

Another idea would be to rename just the _column_ (not the table), but
that doesn't block SELECT * from showing the column.  Another idea would
be to replace tsvector's out function, but that would affect all tables
meaning it would be hard to incrementally rebuild tables using tsvector
columns.  Another idea would be to use column-level permissions to
prevent column access, but that doesn't affect super-users.

-- 
  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

pgsql-hackers by date

Next:From: Tom LaneDate: 2009-05-31 21:35:33
Subject: Re: INTERVAL SECOND limited to 59 seconds?
Previous:From: Josh BerkusDate: 2009-05-31 20:12:36
Subject: Re: search_path improvements

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