I'm trying to write a pl/pgsql trigger to validate incoming data to an existing database. One of the fields is defined
ascharacter 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