Re: RAISE NOTICE

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: RAISE NOTICE
Date: 2009-05-10 10:57:44
Message-ID: gu6bv8$sf$3@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 2009-05-08, Luigi N. Puleio <npuleio(at)rocketmail(dot)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 message like 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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Luigi N. Puleio 2009-05-11 06:02:08 Re: RAISE NOTICE
Previous Message Alvaro Herrera 2009-05-10 02:58:22 Re: Distinct oddity