Fwd: Enhancement Request : Expressions for format string in PlPgsql RAISE statement

From: Laurent Herve <laurent-herve(at)club-internet(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: Fwd: Enhancement Request : Expressions for format string in PlPgsql RAISE statement
Date: 2005-12-04 09:10:41
Message-ID: 200512041010.41961.laurent-herve@club-internet.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello there,

Unfortunately, as I am not a C hacker, I won't be able to do that by myself.
Do you think it is an interesting feature or not ? Is anybody else interested
in it ?
Should I send it to hackers list for TODO item creation request ?

Thanks.

---------- Message transmis ----------

Subject: Enhancement Request : Expressions for format string in PlPgsql RAISE
statement
Date: Samedi 29 Octobre 2005 17:12
From: Laurent HERVE <laurent-herve(at)club-internet(dot)fr>
To: pgsql-general(at)postgresql(dot)org

Hi,

I don't know where to submit enhancement requests. So I'm doing there.

I have to send error messages in several languages within PlPgSQL code.
I would like RAISE to work like that :

RAISE EXCEPTION get_my_format_string(MY_ERR_NBR,USER_LANG),a,b,a+b/c;

where the get_my_format_string returns a format string understandable for
RAISE (like 'initial values = % and % result = %') for each valid combination
of MY_ERR_NBR (my application error number) and USER_LANG (the language in
which I would like the error string to be displayed). I think this would be
really useful to add international support to my PostgreSQL applications.

It seems the 8.1 RAISE statement does not provide such a possibility.

Regards,

-------------------------------------------------------

Browse pgsql-general by date

  From Date Subject
Next Message Eugene Prokopiev 2005-12-04 10:00:52 function in index expression and unnecessary function calls in select
Previous Message Qingqing Zhou 2005-12-04 06:51:52 Re: keeping track of inserts (periodical) into a table