Skip site navigation (1) Skip section navigation (2)

BUG #1056: ecpg ignores WHENEVER NOT FOUND

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1056: ecpg ignores WHENEVER NOT FOUND
Date: 2004-01-20 20:44:30
Message-ID: 20040120204430.C2470CF4C2F@www.postgresql.com (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1056
Logged by:          Wes

Email address:      wespgc(at)syntegra(dot)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.


Responses

pgsql-bugs by date

Next:From: Scott YeadonDate: 2004-01-20 22:37:55
Subject: connection handling in 7.4.1
Previous:From: PostgreSQL Bugs ListDate: 2004-01-20 15:22:30
Subject: BUG #1055: no keys in inherited table with primary key when inserting into inheriting table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group