Thomas Erskine <[EMAIL PROTECTED]> 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)). -Neil ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
