From: Satoshi Nagayasu <satoshi.nagayasu@gmail.com>
To: Greg Smith <greg@2ndquadrant.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-docs <pgsql-docs@postgresql.org>
Subject: Re: ECPG - Some errno definitions don't match to the manual
Date: Tue, 28 Sep 2010 11:38:44 +0900
Message-ID: <4CA15534.1060602@gmail.com> (raw)
In-Reply-To: <4CA1458F.9030707@2ndquadrant.com>
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>
<4CA11FF7.1090403@gmail.com>
<AANLkTikF_=wz9aB4k4YmPD9jyfrAxspyCJwTWKkzCEyO@mail.gmail.com>
<4CA13D11.7050905@gmail.com>
<4CA1458F.9030707@2ndquadrant.com>
On 2010/09/28 10:31, Greg Smith wrote:
> If the patch you generated applies to the git version of the repo cleanly, you may be fine for now. The anon-cvs version is mainly intended as a source to get a copy of the source code just to compile or read, not to develop patches against. For that it would be better to switch to git when you get some time to spend on that.
So, I have created another patch from git repository.
The attached one could be applied to the latest code.
Thanks,
--
NAGAYASU Satoshi <satoshi.nagayasu@gmail.com>
Attachments:ecpg-git.sgml.diff (text/plain, 6.4K) downloaddiff --git a/doc/src/sgml/ecpg.sgml b/doc/src/sgml/ecpg.sgmlindex 3245064..e45ca77 100644--- a/doc/src/sgml/ecpg.sgml+++ b/doc/src/sgml/ecpg.sgml@@ -4794,11 +4794,31 @@ struct
<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. (SQLSTATE- YE001)+ Indicates that your virtual memory is exhausted, defined as <literal>-ENOMEM</literal>.+ (SQLSTATE YE001)
</para>
</listitem>
</varlistentry>
@@ -4886,6 +4906,54 @@ struct
</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,6 +5007,18 @@ struct
</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,6 +5049,18 @@ struct
</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,6 +5113,16 @@ struct
</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,15 +5155,80 @@ struct
</varlistentry>
<varlistentry>
- <term>100 (<symbol>ECPG_NOT_FOUND</symbol>)</term>+ <term>-403 (<symbol>ECPG_DUPLICATE_KEY</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)+ 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, greg@2ndquadrant.com, robertmhaas@gmail.com, peter_e@gmx.net
Subject: Re: ECPG - Some errno definitions don't match to the manual
In-Reply-To: <4CA15534.1060602@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