From: Luigi N. Puleio <npuleio@rocketmail.com>
To: Milen A. Radev <milen@radev.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: RAISE NOTICE
Date: Fri, 8 May 2009 05:01:45 -0700 (PDT)
Message-ID: <496803.4094.qm@web33501.mail.mud.yahoo.com> (raw)
The fact is I have in my postgresql.conf this:
client_min_messages = notice
but if I call the function which has RAISE NOTICE it doesn't return a notice to the clienti...indeed I see it in the logfile on server status...
that's why I was asking if there is a way... maybe I could also have written wrong config for that parameter...
--- On Fri, 5/8/09, Milen A. Radev <milen@radev.net> wrote:
From: Milen A. Radev <milen@radev.net>
Subject: Re: [SQL] RAISE NOTICE
To: pgsql-sql@postgresql.org
Date: Friday, May 8, 2009, 11:52 AM
Luigi N. Puleio написа:
> Sort of....the message should come along a standalone application too when with an ADO component I do a Post() which calls the function...just the matter is I can't modify the application to manage a possibly notification...only the postgresql's function...
> That's why I'm asking about a possibility to get a notification from the function like it's an EXCEPTION...
[...]
I believe the fine manual is clear about this
(http://www.postgresql.org/docs/current/static/plpgsql-errors-and-messages.html):
"Whether messages of a particular priority are reported to the client,
written to the server log, or both is controlled by the log_min_messages
and client_min_messages configuration variables. See Chapter 18 for more
information."
--
Milen A. Radev
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: npuleio@rocketmail.com, milen@radev.net
Subject: Re: RAISE NOTICE
In-Reply-To: <496803.4094.qm@web33501.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox