Simple client messages from within pgPL/SQL

From: "Andre Schnoor" <andre(dot)schnoor(at)web(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Simple client messages from within pgPL/SQL
Date: 2005-02-22 17:10:38
Message-ID: 38178uF5k3llaU1@individual.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm desparately seeking for a simple way to send messages to the client
during the execution of large stored procedures.

RAISE INFO 'Now Processing %', thisCustomer;

Doesn't do it, because the client console is cluttered with verbose context
information (e.g. backtrace). It's impossible to follow these "messages".

I'm afraid that lowering the verbosity level in the server config will also
affect error messages (where verbosity is helpful). Is there another way to
output strings to the "console"?

Any suggestions?
Thanks in advance.

Andre

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Phil Endecott 2005-02-22 17:14:00 Re: Triggers, again.. ;-)
Previous Message Tom Lane 2005-02-22 16:51:48 Re: Triggers, again.. ;-)