> BEGIN
> 
>      DELETE FROM .....
> 
> EXCEPTION
>        WHEN others THEN
>                   ...........
> END;
> 
> documentation:
> http://www.postgresql.org/docs/current/static/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING
> 
> a list of errors:
> http://www.postgresql.org/docs/current/static/errcodes-appendix.html
> 
> --
> regards,

Thanks.

When I use the EXCEPTION and I return a value numeric or text the
Postgresql shows a error of encoding :(... Invalid Encoding UTF-8 at...

This error only occurs when a EXCEPTION treated by me it's raised.

My database is in UTF8 encoding.

What's happen?

E.g:


EXCEPTION
      WHEN others THEN RETURN 'Error';

Marcos.


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to