Re: Create Produre for DROP row

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.

In response to

Browse pgsql-general by date

  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