From: | Marcos <mjs_ops(at)gmx(dot)net> |
---|---|
To: | Jaime Casanova <systemguards(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Create Produre for DROP row |
Date: | 2006-01-20 13:38:32 |
Message-ID: | 1137764312.1009.12.camel@servidor |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Sebastjan Trepca | 2006-01-20 13:47:26 | Re: How to fetch rows with multiple values |
Previous Message | Michael Glaesemann | 2006-01-20 13:30:29 | Re: How to fetch rows with multiple values |