Re: SQLERRM & SQLSTATE

On 6/22/06, Alvaro Herrera <alvherre(at)commandprompt(dot)com> wrote:
> Ë(r)îÇk tåþîå þé(r)Ëz escribió:
> > Saludos lista, los molesto con una duda, estoy tratando de hacer una
> > funcion PL/pgSQL que registra errores (numero y mensaje)generados por
> > sentencias sql (insert, select, update, etc), he encontrado que la variable
> > SQLSTATE contiene el numero y SQLERRM el mensaje de error
>
> De donde sacaste eso?
>

imagino que de la documentacion

http://www.postgresql.org/docs/8.1/static/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING

Within an exception handler, the SQLSTATE variable contains the error
code that corresponds to the exception that was raised (refer to Table
A-1 for a list of possible error codes). The SQLERRM variable contains
the error message associated with the exception. These variables are
undefined outside exception handlers.

--
Atentamente,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
Richard Cook