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

Tom Lane wrote:

> I wonder if it would help to make plpgsql pass the RAISE format string
> through gettext?

Hmm, nice idea.  However,

> This would only be a usable approach if there were some fairly easy way
> to add installation-specific translations to gettext's table.  I don't
> know enough about gettext to know if that's doable.

There are lots of caveats -- the first being that you would need to
extract the messages from the function body.  I don't think there's a
gettext PL/pgSQL parser, so there's a first hurdle there.

Then there's the matter of not mixing the "postgres" message domain with
the user's, so we would need to change it just before calling RAISE and
restore it afterwards.

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