| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Yeadon | 2004-01-20 22:37:55 | connection handling in 7.4.1 |
| Previous Message | PostgreSQL Bugs List | 2004-01-20 15:22:30 | BUG #1055: no keys in inherited table with primary key when inserting into inheriting table |