Date: Wed, 14 May 2008 11:33:37 -0400
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Julius Tuskenis <julius@nsoft.lt>
Cc: pgsql-admin@postgresql.org
Subject: Re: translating exception messages of postgresql functions
Message-ID: <20080514153337.GI5521@alvh.no-ip.org>
References: <482AF7F7.5090309@nsoft.lt> <20080514144627.GD5521@alvh.no-ip.org>
	<482B03B0.8060206@nsoft.lt>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <482B03B0.8060206@nsoft.lt>
User-Agent: Mutt/1.5.17+20080114 (2008-01-14)

Julius Tuskenis wrote:

> I want to translate the exception message. For example I raise an  
> exception in pg function like RAISE EXCEPTION 'my exception', then in my  
> application that calls the function I catch the exception. But before I  
> show it to the user of application I have to translate it. How do I know  
> what exception it is? As Tom Lane answered - the only way is to rely on  
> message text.

You want to translate it from english to another language, or you want
to change the nature of the message reported?  If you just want to
translate it to another language, see here:

http://pgtranslation.projects.postgresql.org/status.html

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support