Re: [ADMIN] Increasing the length of a VARCHAR column without table rewrite

2009-10-23 Thread Alvaro Herrera
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 t

Re: [ADMIN] Increasing the length of a VARCHAR column without table rewrite

2009-10-23 Thread Lewis Kapell
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 imp

[ADMIN] Increasing the length of a VARCHAR column without table rewrite

2009-10-22 Thread Eric Comeau
ALTER TABLE ALTER column TYPE varchar(xxx) We need to increase the length of a varchar(256) column in two of our largest tables preferrably to TEXT. Is there a way to do this without having to go through a complete table rewrite? I have googled and seen the todo on the wiki, but I'm wonde