On 1/16/06, Alvaro Herrera <[EMAIL PROTECTED]> 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 ;) ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
