A question about RAISE NOTICE

From: "Luigi N(dot) Puleio" <npuleio(at)rocketmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: A question about RAISE NOTICE
Date: 2009-05-07 14:35:23
Message-ID: 29592.60792.qm@web33503.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello everyone,

I have a question concerning RAISE NOTICE.... I have a plpgsql function where it has a code like this:

IF (condition) THEN
    RAISE NOTICE 'This condition is verified';
END IF;

and this function is fired when I modify a view's field which as a RULE INSTEAD DO where it calls this function. The result I'd like would be to notice me with a on-display message with a window having an OK button (like when I use EXCEPTION). which would tell me the condition is verified....

I settled client_min_messages to notice which it should return me a message but it doesn't show me any message...

Shall I have missed something maybe?...

Thanks
Ciao
Luigi

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Conrad Lender 2009-05-07 14:42:40 Re: "No transaction in progress" warning
Previous Message Massa, Harald Armin 2009-05-07 14:19:28 Re: Power outage and funny chars in the logs