From: Satoshi Nagayasu <satoshi.nagayasu@gmail.com>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-docs <pgsql-docs@postgresql.org>
Subject: Re: ECPG - Some errno definitions don't match to the manual
Date: Tue, 28 Sep 2010 07:51:35 +0900
Message-ID: <4CA11FF7.1090403@gmail.com> (raw)
In-Reply-To: <1285502270.1601.1.camel@vanquo.pezone.net>
References: <4C4847D0.9030001@gmail.com>
<AANLkTin286hRE0oLZFr4quDp6esNNztHmYUhfLO0vf_4@mail.gmail.com>
<4C602E9D.40501@gmail.com>
<4C60C7A9.10307@gmail.com>
<AANLkTi=xFL3fbLxWJwAi7CJU9R_kiZSLF==3c9-vqRuG@mail.gmail.com>
<4C634586.7090908@gmail.com>
<1285502270.1601.1.camel@vanquo.pezone.net>
Hi Peter,
Thanks for your reviewing.
On 2010/09/26 20:57, Peter Eisentraut wrote:
> On tor, 2010-08-12 at 09:51 +0900, Satoshi Nagayasu wrote:
>> Thank you for the commit, and I'll put the remainder
>> to the commitfest page.
>
> Please submit a new patch that applies on top of what was already
> committed.
Here is a new patch applicable to the cvs head.
Please check it out.
Thanks,
--
NAGAYASU Satoshi <satoshi.nagayasu@gmail.com>
Attachments:ecpg-cvs.sgml.diff (text/plain, 7.2K) download
*** pgsql.orig/doc/src/sgml/ecpg.sgml 2010-09-28 07:34:12.000000000 +0900
--- pgsql/doc/src/sgml/ecpg.sgml 2010-09-28 07:46:19.000000000 +0900
***************
*** 4794,4804 ****
<variablelist>
<varlistentry>
<term>-12 (<symbol>ECPG_OUT_OF_MEMORY</symbol>)</term>
<listitem>
<para>
! Indicates that your virtual memory is exhausted. (SQLSTATE
! YE001)
</para>
</listitem>
</varlistentry>
--- 4794,4824 ----
<variablelist>
<varlistentry>
+ <term>0 (<symbol>ECPG_NO_ERROR</symbol>)</term>+ <listitem>+ <para>+ Indicates no error. (SQLSTATE 00000)+ </para>+ </listitem>+ </varlistentry>+ + <varlistentry>+ <term>100 (<symbol>ECPG_NOT_FOUND</symbol>)</term>+ <listitem>+ <para>+ This is a harmless condition indicating that the last command+ retrieved or processed zero rows, or that you are at the end of+ the cursor. (SQLSTATE 02000)+ </para>+ </listitem>+ </varlistentry>+ + <varlistentry>
<term>-12 (<symbol>ECPG_OUT_OF_MEMORY</symbol>)</term>
<listitem>
<para>
! Indicates that your virtual memory is exhausted, defined as `-ENOMEM'.
! (SQLSTATE YE001)
</para>
</listitem>
</varlistentry>
***************
*** 4886,4891 ****
--- 4906,4959 ----
</varlistentry>
<varlistentry>
+ <term>-207 (<symbol>ECPG_NUMERIC_FORMAT</symbol>)</term>+ <listitem>+ <para>+ The host variable is of type <type>numeric</type> and the datum+ in the database is of another type and contains a value that+ cannot be interpreted as a <type>numeric</type>.+ (SQLSTATE 42804)+ </para>+ </listitem>+ </varlistentry>+ + <varlistentry>+ <term>-208 (<symbol>ECPG_INTERVAL_FORMAT</symbol>)</term>+ <listitem>+ <para>+ The host variable is of type <type>interval</type> and the datum+ in the database is of another type and contains a value that+ cannot be interpreted as a <type>interval</type>.+ (SQLSTATE 42804)+ </para>+ </listitem>+ </varlistentry>+ + <varlistentry>+ <term>-209 (<symbol>ECPG_DATE_FORMAT</symbol>)</term>+ <listitem>+ <para>+ The host variable is of type <type>date</type> and the datum in+ the database is of another type and contains a value that+ cannot be interpreted as a <type>date</type>.+ (SQLSTATE 42804)+ </para>+ </listitem>+ </varlistentry>+ + <varlistentry>+ <term>-210 (<symbol>ECPG_TIMESTAMP_FORMAT</symbol>)</term>+ <listitem>+ <para>+ The host variable is of type <type>timestamp</type> and the+ datum in the database is of another type and contains a value+ that cannot be interpreted as a <type>timestamp</type>.+ (SQLSTATE 42804)+ </para>+ </listitem>+ </varlistentry>+ + <varlistentry>
<term>-211 (<symbol>ECPG_CONVERT_BOOL</symbol>)</term>
<listitem>
<para>
***************
*** 4939,4944 ****
--- 5007,5024 ----
</varlistentry>
<varlistentry>
+ <term>-216 (<symbol>ECPG_ARRAY_INSERT</symbol>)</term>+ <listitem>+ <para>+ The value could not be inserted into the array.(This is+ disabled by <literal>#if 0</literal> in+ <command>ecpg</command>.)+ (SQLSTATE 42804)+ </para>+ </listitem>+ </varlistentry>+ + <varlistentry>
<term>-220 (<symbol>ECPG_NO_CONN</symbol>)</term>
<listitem>
<para>
***************
*** 4969,4974 ****
--- 5049,5066 ----
</varlistentry>
<varlistentry>
+ <term>-239 (<symbol>ECPG_INFORMIX_DUPLICATE_KEY</symbol>)</term>+ <listitem>+ <para>+ Duplicate key error, and a violation for the unique+ constraint (Informix compatible mode).+ (SQLSTATE 23505)+ + </para>+ </listitem>+ </varlistentry>+ + <varlistentry>
<term>-240 (<symbol>ECPG_UNKNOWN_DESCRIPTOR</symbol>)</term>
<listitem>
<para>
***************
*** 5021,5026 ****
--- 5113,5128 ----
</varlistentry>
<varlistentry>
+ <term>-284 (<symbol>ECPG_INFORMIX_SUBSELECT_NOT_ONE</symbol>)</term>+ <listitem>+ <para>+ A result of the subquery is not single row (Informix compatibie mode).+ (SQLSTATE 21000)+ </para>+ </listitem>+ </varlistentry>+ + <varlistentry>
<term>-400 (<symbol>ECPG_PGSQL</symbol>)</term>
<listitem>
<para>
***************
*** 5053,5067 ****
</varlistentry>
<varlistentry>
! <term>100 (<symbol>ECPG_NOT_FOUND</symbol>)</term>
<listitem>
<para>
! This is a harmless condition indicating that the last command
! retrieved or processed zero rows, or that you are at the end of
! the cursor. (SQLSTATE 02000)
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</sect2>
--- 5155,5234 ----
</varlistentry>
<varlistentry>
! <term>-403 (<symbol>ECPG_DUPLICATE_KEY</symbol>)</term>
<listitem>
<para>
! Duplicate key error, and a violation for the unique
! constraint.
! (SQLSTATE 23505)
! </para>
! </listitem>
! </varlistentry>
!
! <varlistentry>
! <term>-404 (<symbol>ECPG_SUBSELECT_NOT_ONE</symbol>)</term>
! <listitem>
! <para>
! A result for the subquery is not single row. (SQLSTATE 21000)
! </para>
! </listitem>
! </varlistentry>
!
! <varlistentry>
! <term>-600 (<symbol>ECPG_WARNING_UNRECOGNIZED</symbol>)</term>
! <listitem>
! <para>
! A query is ignored by the END.
! </para>
! </listitem>
! </varlistentry>
!
! <varlistentry>
! <term>-601 (<symbol>ECPG_WARNING_QUERY_IGNORED</symbol>)</term>
! <listitem>
! <para>
! Current transaction is aborted. Query is ignored by end of the
! transaction block.
! </para>
! </listitem>
! </varlistentry>
!
! <varlistentry>
! <term>-602 (<symbol>ECPG_WARNING_UNKNOWN_PORTAL</symbol>)</term>
! <listitem>
! <para>
! Invalid cursor name is given. (SQLSTATE 34000)
! </para>
! </listitem>
! </varlistentry>
!
! <varlistentry>
! <term>-603 (<symbol>ECPG_WARNING_IN_TRANSACTION</symbol>)</term>
! <listitem>
! <para>
! Transaction is in progress. (SQLSTATE 25001)
! </para>
! </listitem>
! </varlistentry>
!
! <varlistentry>
! <term>-604 (<symbol>ECPG_WARNING_NO_TRANSACTION</symbol>)</term>
! <listitem>
! <para>
! There is no active (in-progress) transaction. (SQLSTATE 25P01)
</para>
</listitem>
</varlistentry>
+ + <varlistentry>+ <term>-605 (<symbol>ECPG_WARNING_PORTAL_EXISTS</symbol>)</term>+ <listitem>+ <para>+ An existing cursor name is specified. (SQLSTATE 42P03)+ </para>+ </listitem>+ </varlistentry>+
</variablelist>
</para>
</sect2>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: satoshi.nagayasu@gmail.com, peter_e@gmx.net, robertmhaas@gmail.com
Subject: Re: ECPG - Some errno definitions don't match to the manual
In-Reply-To: <4CA11FF7.1090403@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox