Lewis Kapell wrote: > Eric, > > Is the table in question so large that you can't afford the time it > would take to perform ALTER COLUMN TYPE? > > I definitely would not go poking around in system catalogs and > changing things there. Not unless you *want* to trash your > database... The fact that 'todo' has not yet been implemented > suggests that it is not a simple matter of changing one attribute in > a system catalog.
Well, it is (in this case at least) -- the problem is that we want a general solution, not one that only applies to the particular problem of widening a column's max length. (When playing with this, however, note that the modified table may need a toast table that may not be there). -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
