Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id D25FA63459A; Thu, 22 Jul 2010 10:30:22 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 66018-03; Thu, 22 Jul 2010 13:30:14 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-pv0-f174.google.com (mail-pv0-f174.google.com [74.125.83.174]) by mail.postgresql.org (Postfix) with ESMTP id 70D5B634535; Thu, 22 Jul 2010 10:30:14 -0300 (ADT) Received: by pvc7 with SMTP id 7so3025026pvc.19 for ; Thu, 22 Jul 2010 06:30:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from :user-agent:mime-version:to:subject:content-type :content-transfer-encoding; bh=slLMrH6MGiESzusKovxAQPS6SrAp6t7b3KAHt0TXm9k=; b=brh9DcWEg0PP6/z6Quq1iTa80c0milyQDl/QNUrgcG7UKs9jAoTeNbTKw2YsQwzPNY baeO3cYesmv/6H6Z2mhrGjxBL75NwRoBdVa3sVq1GIhtr9iVNDkgCHt1wfpYvzzA7mcy xRfs9yjaOLYinAnb5byikN9Xb0uWoOS67eYt0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:subject :content-type:content-transfer-encoding; b=GKLLqynqEMsaMde5AQSaGk7Ws5EmVf5agFDRpuzoDrLZH/y0VP0Fnolt3yREqLu5m+ 67bb96Uypo8ppvePE/NXav0NRvjdNzZ4S8sv6m2X9Oa3dVqDpsylWdv+1bv0IooT6uSv T2y1aEMMeOItHkEceU3fgLUuIL7upBHpvu7vg= Received: by 10.114.79.1 with SMTP id c1mr2284219wab.118.1279805399151; Thu, 22 Jul 2010 06:29:59 -0700 (PDT) Received: from [10.0.2.101] (p0245ed.tokyff01.ap.so-net.ne.jp [121.2.69.237]) by mx.google.com with ESMTPS id g4sm84138388wae.14.2010.07.22.06.29.56 (version=TLSv1/SSLv3 cipher=RC4-MD5); Thu, 22 Jul 2010 06:29:57 -0700 (PDT) Message-ID: <4C4847D0.9030001@gmail.com> Date: Thu, 22 Jul 2010 22:29:52 +0900 From: Satoshi Nagayasu User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; ja; rv:1.9.2.7) Gecko/20100713 Thunderbird/3.1.1 MIME-Version: 1.0 To: pgsql-docs , pgsql-general@postgresql.org Subject: ECPG - Some errno definitions don't match to the manual Content-Type: text/plain; charset=ISO-2022-JP Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201007/144 X-Sequence-Number: 5800 Hi all, I'm looking into some ecpg part of the official manual, and I have found some strange things. I'm now investigating SQLCODE and SQLSTATE, and I have found that some of the errno definitions don't match to the manual. For example, the manual says that ECPG_CONVERT_BOOL could be `-207'. However, ECPG_CONVERT_BOOL is defined as `-211' in ecpgerrno.h. > -207 (ECPG_CONVERT_BOOL) > > This means the host variable is of type bool and the datum in the database is neither 't' nor 'f'. (SQLSTATE 42804) http://www.postgresql.org/docs/9.0/static/ecpg-errors.html > #define ECPG_NUMERIC_FORMAT -207 > #define ECPG_CONVERT_BOOL -211 http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/include/ecpgerrno.h?rev=1.27;content-type=text%2Fx-cvsweb-markup;only_with_tag=REL9_0_STABLE What does it mean? The manual is not up to date? Any suggestions? Regards, -- NAGAYASU Satoshi