Searching the archives lead me to this link: http://archives.postgresql.org/pgsql-general/2001-10/msg01208.php (I also searched before asking but for the wrong keywords...) Is that advice still valid ? I will try in any case :-) Thanks, Csaba. On Wed, 2005-05-11 at 15:44, Tom Lane wrote: > Csaba Nagy <nagy@xxxxxxxxxxxxxx> writes: > > 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). > > Why don't you just hack the column's atttypmod? See the archives > (and practice on a test database ;-)) > > regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
