I'm trying to write a pl/pgsql trigger to validate incoming data to an existing database. One of the fields is defined as character varying (255). Is there any way of catching over-length data on inserts and silently dropping them? At the moment, I'm getting the error 'ERROR: value too long for type character varying(255)' no matter what I try. And yes, I inherited this! Cheers, Steve
