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