Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id E56522E0064 for ; Wed, 14 May 2008 11:38:29 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 99867-02-2 for ; Wed, 14 May 2008 11:38:13 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from vilnius.balt.net (vilnius.balt.net [195.14.170.14]) by developer.postgresql.org (Postfix) with ESMTP id DD5D22E0165 for ; Wed, 14 May 2008 11:32:26 -0300 (ADT) Received: from nSoft.lt (unknown [217.117.29.29]) by vilnius.balt.net (Postfix) with ESMTP id C4545398815 for ; Wed, 14 May 2008 17:32:23 +0300 (EEST) Received: from [192.168.16.191] (unknown [192.168.16.191]) by nSoft.lt (Postfix) with ESMTP id 4BA88BF2FE for ; Wed, 14 May 2008 18:13:36 +0000 (GMT) Message-ID: <482AF7F7.5090309@nsoft.lt> Date: Wed, 14 May 2008 17:32:23 +0300 From: Julius Tuskenis User-Agent: Thunderbird 2.0.0.14 (Windows/20080421) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: translating exception messages of postgresql functions Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.202 tagged_above=0 required=5 tests=AWL=0.202 X-Spam-Level: X-Archive-Number: 200805/116 X-Sequence-Number: 29200 Hello, I'd like to ask how is translation of raised exceptions done in postgresql applications? In Sybase ASA you can specify the error number when raising it, but in postgresql theres just exception message. As I've read - postgresql always generates P0001 SQLSTATE code for raised exceptions. Have enyone tried to distinguish one exception from the other in the application? -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050