Re: ECPG oracle mode test program patch

Lists: pgsql-hackers
From: "Shinoda, Noriyoshi" <noriyoshi(dot)shinoda(at)hpe(dot)com>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, David Rader <davidr(at)openscg(dot)com>, Michael Meskes <meskes(at)postgresql(dot)org>
Subject: ECPG oracle mode test program patch
Date: 2018-03-17 13:25:34
Message-ID: TU4PR8401MB0797C0E3F3208661D0718D9EEED60@TU4PR8401MB0797.NAMPRD84.PROD.OUTLOOK.COM
Views: Whole Thread | Raw Message | Download mbox | Resend email
Lists: pgsql-hackers

Hi, Hackers

The attached small patch is a modification to the test program of the function recently added to ECPG.
[Add Oracle like handling of char arrays.]
https://git.postgresql.org/pg/commitdiff/3b7ab4380440d7b14ee390fabf39f6d87d7491e2

When the char_array program is executed, the following error occurs in the closed part of the CURSOR.

[NO_PID]: ecpg_check_PQresult on line 54: bad response - ERROR: cursor "cstr" does not exist
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: raising sqlstate 34000 (sqlcode -400): cursor "cstr" does not exist on line 54

The attached patch corrects the cursor name.

Regards,

Noriyoshi Shinoda

Attachment Content-Type Size
char_array.patch application/octet-stream 489 bytes

From: Michael Meskes <meskes(at)postgresql(dot)org>
To: "Shinoda, Noriyoshi" <noriyoshi(dot)shinoda(at)hpe(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, David Rader <davidr(at)openscg(dot)com>
Subject: Re: ECPG oracle mode test program patch
Date: 2018-03-17 17:16:19
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Lists: pgsql-hackers

> The attached patch corrects the cursor name.

Fixed, thanks for the patch.

Michael
--
Michael Meskes
Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
Meskes at (Debian|Postgresql) dot Org
Jabber: michael at xmpp dot meskes dot org
VfL Borussia! Força Barça! SF 49ers! Use Debian GNU/Linux, PostgreSQL