Re: [GENERAL] Fixing a too long column value in a before insert

2005-05-11 Thread Csaba Nagy
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: > Csa

Re: [GENERAL] Fixing a too long column value in a before insert trigger or rule

2005-05-11 Thread Tom Lane
Csaba Nagy <[EMAIL PROTECTED]> 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 an

Re: [GENERAL] Fixing a too long column value in a before insert trigger or rule

2005-05-11 Thread Douglas McNaught
Csaba Nagy <[EMAIL PROTECTED]> 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

[GENERAL] Fixing a too long column value in a before insert trigger or rule

2005-05-11 Thread Csaba Nagy
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 onl