Re: full featured alter table? - Mailing list pgsql-general

From weigelt@metux.de
Subject Re: full featured alter table?
Date
Msg-id 20030614204501.GA18471@metux.de
Whole thread Raw
In response to Re: full featured alter table?  (Sven Köhler <skoehler@upb.de>)
Responses Re: full featured alter table?  (Sven Köhler <skoehler@upb.de>)
List pgsql-general
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@metux.de
 cellphone: +49 174 7066481         smsgate:   sms.weigelt@metux.de
---------------------------------------------------------------------
 Diese Mail wurde mit UUCP versandt.      http://www.metux.de/uucp/

pgsql-general by date:

Previous
From: weigelt@metux.de
Date:
Subject: Re: full featured alter table?
Next
From: Kenneth Godee
Date:
Subject: Re: Growing Database Size