Thread: BUG #1056: ecpg ignores WHENEVER NOT FOUND

BUG #1056: ecpg ignores WHENEVER NOT FOUND

From
"PostgreSQL Bugs List"
Date:
The following bug has been logged online:

Bug reference:      1056
Logged by:          Wes

Email address:      wespgc@syntegra.com

PostgreSQL version: 7.4

Operating system:   Redhat Linux 7.3

Description:        ecpg ignores WHENEVER NOT FOUND

Details:

This problem occurs with both 7.4 and 7.4.1.  The problem does not occur at
7.3.4.

I have a statement in my program such as:

 EXEC SQL WHENEVER NOT FOUND GOTO nextvalError;

The C code generated by ecpg at 7.4 and 7.4.1 is missing the statement:

 if (sqlca.sqlcode == ECPG_NOT_FOUND) goto nextvalError;

My workaround is to manually insert this code in my program.

Re: BUG #1056: ecpg ignores WHENEVER NOT FOUND

From
Michael Meskes
Date:
On Tue, Jan 20, 2004 at 04:44:30PM -0400, PostgreSQL Bugs List wrote:
> Description:        ecpg ignores WHENEVER NOT FOUND

> ...
> This problem occurs with both 7.4 and 7.4.1.  The problem does not occur at
> ...
> I have a statement in my program such as:
>
>  EXEC SQL WHENEVER NOT FOUND GOTO nextvalError;
>
> The C code generated by ecpg at 7.4 and 7.4.1 is missing the statement:
>
>  if (sqlca.sqlcode == ECPG_NOT_FOUND) goto nextvalError;

For future bug reports, please add a test case as I can only guess now
what you're seeing.

I have found a bug and committed the fix to CVS, but I cannot tell now
if it also fixes your problem.

Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!