Обсуждение: RAISE NOTICE
<table border="0" cellpadding="0" cellspacing="0"><tr><td style="font: inherit;" valign="top">Hello everyone...<br /><br/>I have a PL/PgSQL function where I use RAISE NOTICE but this kind of RAISE can't be shown on windows with a popupmessage like the EXCEPTION, indeed it goes to log messages list..<br />So, is there any way to show a popup messagewith a custom textmessage on it from a PL/PgSQL function?...<br /><br />Thanks to all in advance,<br />Ciao<br />Luigi<br/></td></tr></table><br />
Luigi N. Puleio wrote: > Hello everyone... > > I have a PL/PgSQL function where I use RAISE NOTICE but this kind of RAISE can't be shown on windows with a popup messagelike the EXCEPTION, indeed it goes to log messages list.. > So, is there any way to show a popup message with a custom textmessage on it from a PL/PgSQL function?... > > Thanks to all in advance, > Ciao > Luigi > > > > That looks like a sql-client (pgAdmin, pgAccess,?) implementation feature, isnt? Gerardo
| 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... --- On Fri, 5/8/09, Gerardo Herzig <gherzig@fmed.uba.ar> wrote:
|
Luigi N. Puleio написа: > Sort of....the message should come along a standalone application too when with an ADO component I do a Post() which callsthe function...just the matter is I can't modify the application to manage a possibly notification...only the postgresql'sfunction... > 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
| 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:
|
Luigi N. Puleio wrote: > --- On Fri, 5/8/09, Gerardo Herzig <gherzig@fmed.uba.ar> wrote: > > From: Gerardo Herzig <gherzig@fmed.uba.ar> > Subject: Re: [SQL] RAISE NOTICE > To: "Luigi N. Puleio" <npuleio@rocketmail.com> > Cc: pgsql-sql@postgresql.org > Date: Friday, May 8, 2009, 11:34 AM > > Luigi N. Puleio wrote: >> Hello everyone... >> >> I have a PL/PgSQL function where I use RAISE NOTICE but this kind of RAISE can't be shown on windows with a popup messagelike the EXCEPTION, indeed it goes to log messages list.. >> So, is there any way to show a popup message with a custom textmessage on it from a PL/PgSQL function?... >> >> Thanks to all in advance, >> Ciao >> Luigi >> >> >> >> > That looks like a sql-client (pgAdmin, pgAccess,?) implementation > feature, isnt? > > Gerardo > > 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... > Well, in that case, the ADO component is the client. This is the place to modify de code, to capture the NOTICE. Im shure the ADO (or any other component who actually connect to the database and makes the query) has the ability to react when an EXCEPTION is thrown. My guess is that EXCEPTION's goes trough StandardError, but NOTICE's goes trough StandardOutput, and that could be some idea why your app is not getting notice about NOTICES :) I will wait for some expert dude to respond this, because im going myself into unknown territory. Gerardo
On 2009-05-08, Luigi N. Puleio <npuleio@rocketmail.com> wrote: > > --0-1541576050-1241773508=:80512 > Content-Type: text/plain; charset=us-ascii > > Hello everyone... > > I have a PL/PgSQL function where I use RAISE NOTICE but this kind of RAISE can't be shown on windows with a popup messagelike the EXCEPTION, indeed it goes to log messages list.. > So, is there any way to show a popup message with a custom textmessage on it from a PL/PgSQL function?... postgres doesn't produce popups (your application does that) To get notification you need to call PQsetNoticeProcessor() to register a callback function.
| Hello Jasen, do you know if PQsetNoticeProcessor() is appliable to ADOQuery->Post()? I mean if I have an event where there's ADOQuery->Post(), should I do something like: returnvalue = ADOQuery->Post(); PQsetNoticeProcessor(ADOConnection, PQnoticeProcessor, returnvalue);right?... --- On Sun, 5/10/09, Jasen Betts <jasen@xnet.co.nz> wrote:
|
On 2009-05-11, Luigi N. Puleio <npuleio@rocketmail.com> wrote: > > --0-1686780820-1242021728=:49174 > Content-Type: text/plain; charset=us-ascii > > Hello Jasen, > > do you know if PQsetNoticeProcessor() is appliable to ADOQuery->Post()? > > I mean if I have an event where there's ADOQuery->Post(), should I do something like: > > returnvalue = ADOQuery->Post(); > PQsetNoticeProcessor(ADOConnection, PQnoticeProcessor, returnvalue); > right?... I suspect that you'll need to get the PQ connection from ADO and use that in the PQsetNoticeProcessor call. this may not be easy. OTOH ADO may already do that if you can fogure out how to enable the feature. > --- On Sun, 5/10/09, Jasen Betts <jasen@xnet.co.nz> wrote: > > From: Jasen Betts <jasen@xnet.co.nz> > Subject: Re: [SQL] RAISE NOTICE > To: pgsql-sql@postgresql.org > Date: Sunday, May 10, 2009, 10:57 AM > > On 2009-05-08, Luigi N. Puleio <npuleio@rocketmail.com> wrote: >> >> --0-1541576050-1241773508=:80512 >> Content-Type: text/plain; charset=us-ascii >> >> Hello everyone... >> >> I have a PL/PgSQL function where I use RAISE NOTICE but this kind of RAISE can't be shown on windows with a popup messagelike the EXCEPTION, indeed it goes to log messages list.. >> So, is there any way to show a popup message with a custom textmessage on it from a PL/PgSQL function?... > > postgres doesn't produce popups (your application does that) > > To get notification you need to call PQsetNoticeProcessor() to register a callback function. >