Re: [HACKERS] message for constraint

On 1/16/06, Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:
> Jaime Casanova wrote:
> > On 1/16/06, Bruce Momjian <pgman@candle.pha.pa.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.
>

ok... maybe notice? log? i suppose that the ERROR  line is error level
so the idea is lowering the context so i can put
client_min_messages='error' and see just what the user can
understand...


--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)