pg_migrator and making columns invisible - Mailing list pgsql-hackers

From Bruce Momjian
Subject pg_migrator and making columns invisible
Date
Msg-id 200906021354.n52Dsqa29305@momjian.us
Whole thread Raw
Responses Re: pg_migrator and making columns invisible  (Bruce Momjian <bruce@momjian.us>)
Re: pg_migrator and making columns invisible  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
pg_migrator requies tables using tsvector data types to be rebuilt, and
there has been discussion of how to prevent people from accessing those
columns before they are rebuilt.  We discussed renaming the tables
(affects all columns) or columns, using rules (not fine-grained enough),
or using column permissions (doesn't affect super-users).

My new idea is to mark the column as "dropped" and unmark them before
rebuilding the table.  That might be the best I can do.  Comments?

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: Marko Kreen
Date:
Subject: Re: [RFC,PATCH] SIGPIPE masking in local socket connections
Next
From: Robert Haas
Date:
Subject: Re: explain analyze rows=%.0f