Re: full featured alter table?

On Sat, Jun 14, 2003 at 10:21:16PM +0200, Sven K?hler wrote:

<snip>
> >Yeah, and then an application comes in and wants to write more than
> >20 chars ...
>
> why should i define a column as varchar(20) and should than want to
> write more data than that?
> i'd only define it as varchar(20) if i'm sure that 20 chars are enough.
Perhaps there's still some code which still expects longer fields ?
especially in larger applications w/ many developers/admis this can
be really dangerous.

well, if you really want to do this, an perl script which creates
a new table and copies the data could also suit your needs.

we shouldnt make the postmaster codebase too big. each single line
can contain many errors.

cu
--
---------------------------------------------------------------------
Enrico Weigelt == metux ITS
Webhosting ab 5 EUR/Monat. UUCP, rawIP und vieles mehr.

phone: +49 36207 519931 www: http://www.metux.de/
fax: +49 36207 519932 email: contact(at)metux(dot)de
cellphone: +49 174 7066481 smsgate: sms(dot)weigelt(at)metux(dot)de
---------------------------------------------------------------------
Diese Mail wurde mit UUCP versandt. http://www.metux.de/uucp/