Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] message for constraint

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Jaime Casanova <systemguards(at)gmail(dot)com>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>,Peter Eisentraut <peter_e(at)gmx(dot)net>,PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [HACKERS] message for constraint
Date: 2006-01-16 20:49:55
Message-ID: 20060116204955.GC32100@surnet.cl (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
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)

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2006-01-16 20:52:01
Subject: Anyone see a need for BTItem/HashItem?
Previous:From: Jonathan GardnerDate: 2006-01-16 20:45:37
Subject: Re: source documentation tool doxygen

pgsql-patches by date

Next:From: Jaime CasanovaDate: 2006-01-16 20:59:45
Subject: Re: [HACKERS] message for constraint
Previous:From: Jaime CasanovaDate: 2006-01-16 20:44:25
Subject: Re: [HACKERS] message for constraint

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group