Tom Lane wrote: > Bruce Momjian <[email protected]> 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.
How do cleanup all references to the tsvector data type? I am afraid there will be tons of tsvector references outside tables that I can't clean up. -- Bruce Momjian <[email protected]> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
