Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id A47DD2E003F for ; Fri, 18 Apr 2008 01:22:13 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 88397-08 for ; Fri, 18 Apr 2008 01:22:09 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from www.postnewspapers.com.au (www.postnewspapers.com.au [202.61.230.242]) by developer.postgresql.org (Postfix) with ESMTP id F36F32E002C for ; Fri, 18 Apr 2008 01:22:09 -0300 (ADT) Received: from mail.postnewspapers.com.au (202-89-185-120.static.dsl.amnet.net.au [202.89.185.120]) by www.postnewspapers.com.au (Postfix) with ESMTP id 43F7FC2BF; Fri, 18 Apr 2008 12:22:05 +0800 (WST) Received: from localhost (access [127.0.0.1]) by mail.postnewspapers.com.au (Postfix) with ESMTP id 7DACA1E0435; Fri, 18 Apr 2008 12:22:08 +0800 (WST) X-Virus-Scanned: Debian amavisd-new at postnewspapers.com.au Received: from mail.postnewspapers.com.au ([127.0.0.1]) by localhost (access.postnewspapers.com.au [127.0.0.1]) (amavisd-new, port 10024) with LMTP id Ub6uqvjLvNcd; Fri, 18 Apr 2008 12:22:06 +0800 (WST) Received: from [203.161.97.213] (203.161.97.213.static.amnet.net.au [203.161.97.213]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "Craig Ringer", Issuer "POST Certificate Authority" (verified OK)) by mail.postnewspapers.com.au (Postfix) with ESMTP id 742641E0434; Fri, 18 Apr 2008 12:22:06 +0800 (WST) Message-ID: <480821DA.1000404@postnewspapers.com.au> Date: Fri, 18 Apr 2008 12:21:46 +0800 From: Craig Ringer User-Agent: Thunderbird 2.0.0.12 (Windows/20080213) MIME-Version: 1.0 To: Tom Lane Cc: pgsql-performance@postgresql.org Subject: Re: SQL Function Slowness, 8.3.0 References: <8328.1208358587@sss.pgh.pa.us> <1208448751.4259.317.camel@ebony.site> <20970.1208448770@sss.pgh.pa.us> <1208449557.4259.331.camel@ebony.site> <4807823B.40706@postnewspapers.com.au> <621.1208475534@sss.pgh.pa.us> <4808185D.3070307@postnewspapers.com.au> <17943.1208491312@sss.pgh.pa.us> In-Reply-To: <17943.1208491312@sss.pgh.pa.us> X-Enigmail-Version: 0.95.6 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/261 X-Sequence-Number: 29754 Tom Lane wrote: > Craig Ringer writes: > >> Tom Lane wrote: >> >>> Craig Ringer writes: >>> >>>> Speaking of this sort of support tool, what I personally often wish for >>>> is unique error message identifiers that can be looked up (say, with a >>>> web form) or a way to un/re-translate localized messages. >>>> >>> The VERBOSE option already gives an exact pointer into the backend >>> sources... >>> >>> >> The trouble is getting people to use it. >> > > Sure, but what's your point? They won't provide a unique message > identifier without being pushed, either. (No, having such a thing > displayed by default isn't going to happen.) Indeed. I was thinking of something like that appearing in default error messages, otherwise I agree it'd be useless. It's just casual speculation anyway, bought on by the previous discussion and thinking about the fact that when working under Windows I actually find the VC++ `C' error codes _useful_. I'm more interested in re-translating messages, which I'll be having a bash at shortly. It's hardly important either (it's often possible to just figure it out given the context, or use the horribly mangled result from google translate to guess) but might be handy if it proves easy to put together. -- Craig Ringer