Re: Logging SQL queries?

Hi,

just my two cents worth tho. I'd love having some kind of "internal log
facility", which means being able to do the follwing:

a) using log functions in every place where common SQL is allowed, which
counts for
    - selects, updates, inserts, deletes (in transaction blocks)
    - triggers
    - functions

b) setting a log level

c) setting which log levels (and greater) really get logged

For example:

    CREATE FUNCTION foobar RETURNS INTEGER AS '
    DECLARE
    ...
    BEGIN
     ...
     IF ...
       LOG('executing if-branch in foobar for value = ' || someval, 2);
     END IF;
     ...
    ...
    END;
    ' LANGUAGE 'plpgsql';

So within any application or psql session one can decide what gets logged
by using:

    SET LOGLEVEL TO 1;

which means logging all messages with a level of 1 or higher.

Just a proposal for future enhancement probably. Open for any comments,
requests... what do others think about that debugging possibility?


Kind regards
... Ralph ...