Re: elog() patch

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Zeugswetter Andreas SB SD <ZeugswetterA(at)spardat(dot)at>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: elog() patch
Date: 2002-03-01 18:06:03
Message-ID: Pine.LNX.4.30.0203011303160.687-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Zeugswetter Andreas SB SD writes:

> I am referring to "completion condition" messages according to SQLSTATE:
>
> 00xxx: Success

This is an INFO (or no message at all). The idea was that things like the
automatic index creation for a PK would be INFO, and you could easily turn
off INFO somehow.

> 01xxx: Success with Warning

This is a NOTICE.

> 02xxx: Success but no rows found

This is nothing special.

> 03 and > : Failure

This is is ERROR or above.

> I see that there is no notion of INFO, thus I agree that INFO should not be
> something normally sent to the user. INFO could be the first DEBUG Level,
> or completely skipped.

It's sort of the "tip" level. A lot of people don't like to see them, so
it's reasonable to separate them from NOTICE. You could think of them as
first debug level, if you like.

--
Peter Eisentraut peter_e(at)gmx(dot)net

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-03-01 18:07:59 Re: elog() patch
Previous Message Justin Clift 2002-03-01 17:47:50 Re: Database Caching