Re: [HACKERS] message for constraint

Jaime Casanova wrote:
> On 1/16/06, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> wrote:

> what about lower the context part of the messages for plpgsql
> functions? that seems debug info for me... just an idea ;)
>
> pruebas=# select prueba();
> ERROR: new row for relation "foo" violates check constraint "foo_fld_check"
> CONTEXT: SQL statement "insert into foo values (-1)"
> PL/pgSQL function "prueba" line 2 at SQL statement

It's not debug info in the sense of the DEBUG error levels. These are
meant as debug info of the server itself, like, say, a transaction
started. The CONTEXT line is exactly that, context information.

--
Alvaro Herrera http://www.advogato.org/person/alvherre
"World domination is proceeding according to plan" (Andrew Morton)