It looks like exceptions are not raise in triggers as expected.

example:

1. trigger function

BEGIN
EXCEPTION
WHEN OTHERS THEN
RAISE NOTICE '% already exist.',NEW."UNAME";
END;

I've tried a before and after trigger
I've also tried the sql error codes for a violation of a UNIQUE
constraint but still no luck.

The the examples of the manual every example have a INSERT or UPDATE
statement before the
EXCEPTION WHEN and it's not done within a trigger.

I would love to make it "GLOBAL" so it does not matter if the INSERT
or UPDATE get called by a FUNCTION or not, thats why I want the
constrain violation to be trapped within a TRIGGER.

Is this possible or not ?

Thanks a mil.