Re: [SQL] RAISE NOTICE
On 2009-05-08, Luigi N. Puleio 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. -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] RAISE NOTICE
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 wrote: From: Jasen Betts Subject: Re: [SQL] RAISE NOTICE To: [email protected] Date: Sunday, May 10, 2009, 10:57 AM On 2009-05-08, Luigi N. Puleio 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. -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] Distinct oddity
am 10.05.2009 4:58 Uhr schrieb Alvaro Herrera unter [email protected]: >>> and what locale are you running in? >> >> lc_collate | de_DE >> | Shows the collation order locale. >> lc_ctype| de_DE >> | Shows the character classification and case conversion locale. >> >> The encoding is UTF-8. > > Note that the de_DE locale uses Latin9 encoding, which is incompatible > with UTF8. Ah, good catch. > I'd try checking if the problem is reproducible in > de_DE.utf8 (you need to create a new database for testing, obviously). Wait a minute. I need to re- initdb with de_DE.UTF-8, don't I? > If it's not, then the incompatible locale definition is causing the > problem. I'll try that, thanks. M -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
