Thomas Erskine <thomas(dot)erskine(at)sympatico(dot)ca> writes:
> A before trigger doesn't always fire. If a column being inserted into is
> too small for the incoming data, psql complains:
> ERROR: value too long for type ...
> without giving the trigger procedure a chance to deal with it.
I believe this is a feature, not a bug: a CHAR(4) field should never,
ever contain > 4 characters. Whether there is a trigger that is yet to
be processed is not relevant.
I'd suggest changing the type of the column to be TEXT, or similar
(which should be just as efficient CHAR(4)).
In response to
pgsql-bugs by date
|Next:||From: Neil Conway||Date: 2003-11-10 19:37:51|
|Subject: Re: COPY and sequences|
|Previous:||From: Gaetano Mendola||Date: 2003-11-10 00:24:46|
|Subject: Re: Autocomplete <TAB> on Postgres7.4beta5 not working?|