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 <mi...@radev.net> wrote: From: Milen A. Radev <mi...@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
