Csaba Nagy <nagy@xxxxxxxxxxxxxx> writes: > Hi all, > > We have a situation where a varchar column was limited to a too small > maximum length in the design phase... shit happens, we will fix our db > schema in our next database downtime or software version deployment, > whichever comes first (we are using 7.4 and on the fly column type > change is only from 8.0 on I guess). You can do surgery on the system catalogs in 7.4 if you need to change the length of a varchar. 8.0 just put a nice ALTER TABLE interface on top of it. Read the system catalog docs and definitely try it on a test database first. :) -Doug ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
