Re: pg_migrator and making columns invisible - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_migrator and making columns invisible
Date
Msg-id 11718.1243952948@sss.pgh.pa.us
Whole thread Raw
In response to pg_migrator and making columns invisible  (Bruce Momjian <bruce@momjian.us>)
Responses Re: pg_migrator and making columns invisible  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> 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?

You're expending a lot of work on solving the wrong problem.  The right
solution is a temporary data type.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Markus Wanner"
Date:
Subject: Re: PostgreSQL Developer meeting minutes up
Next
From: Jeremy Kerr
Date:
Subject: Re: [RFC,PATCH] SIGPIPE masking in local socket connections