Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-general-owner+M208866=pgsql-general-arkari@postgresql.org>)
 id 1XeSH5-0008KR-SD
 for pgsql-general@arkaria.postgresql.org; Wed, 15 Oct 2014 17:22:11 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-general-owner+M208866=pgsql-general-arkari@postgresql.org>)
 id 1XeSH5-0008AF-7M
 for pgsql-general@arkaria.postgresql.org; Wed, 15 Oct 2014 17:22:11 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
 by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <pierce@hogranch.com>) id 1XeSH3-00087I-AQ
 for pgsql-general@postgresql.org; Wed, 15 Oct 2014 17:22:09 +0000
Received: from hogranch.com ([75.101.82.47])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <pierce@hogranch.com>) id 1XeSH0-0004MJ-9a
 for pgsql-general@postgresql.org; Wed, 15 Oct 2014 17:22:07 +0000
Received: from [192.168.0.2] (porker [192.168.0.2])
 by hogranch.com (8.11.6/8.11.6) with ESMTP id s9FHLwZ32719
 for <pgsql-general@postgresql.org>; Wed, 15 Oct 2014 10:21:58 -0700
Message-ID: <543EAD31.3060208@hogranch.com>
Date: Wed, 15 Oct 2014 10:21:53 -0700
From: John R Pierce <pierce@hogranch.com>
User-Agent: Mozilla/5.0 (Windows NT 6.3; WOW64;
 rv:24.0) Gecko/20100101 Thunderbird/24.6.0
MIME-Version: 1.0
To: pgsql-general@postgresql.org
Subject: Re: Any postgres API available to get errorcode for PQerrorMessage
References: <F9567754259D974D88F5F5337C9D219620BD0C43@xmb-aln-x11.cisco.com>
 <4478.1413390995@sss.pgh.pa.us>
 <F9567754259D974D88F5F5337C9D219620BD0F23@xmb-aln-x11.cisco.com>
In-Reply-To: <F9567754259D974D88F5F5337C9D219620BD0F23@xmb-aln-x11.cisco.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-HawgScanner-Information: Please contact the ISP for more information
X-HawgScanner: Found to be clean
X-Pg-Spam-Score: -1.9 (-)
List-Archive: <http://archives.postgresql.org/pgsql-general>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-general.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@postgresql.org>
List-Post: <mailto:pgsql-general@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-general>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
X-Mailing-List: pgsql-general
Precedence: bulk
Sender: pgsql-general-owner@postgresql.org

On 10/15/2014 9:48 AM, Roopeshakumar Narayansa Shalgar (rshalgar) wrote:
> I need the 'integer' errorcode

SQLSTATE Error codes are NOT integers, they are strings.  note there's 
stuff in there like 0100C, 01P01, etc.


-- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general