Message-ID: <1506847463.2588.50.camel@postgresql.org>
Subject: Re: Inserting using SQL descriptors in ECPG in
 different versions of Linux
From: Michael Meskes <meskes@postgresql.org>
To: pgsql-interfaces@postgresql.org
Cc: Anders Nilsson <anders.nilsson@noaa.gov>
Date: Sun, 01 Oct 2017 10:44:23 +0200
In-Reply-To: 
 <CAEx11v5ScGENAcDVfMVuKMaBMMGkdrdqtSgAmfF_NaBihKkY+g@mail.gmail.com>
References: 
	<CAEx11v5ScGENAcDVfMVuKMaBMMGkdrdqtSgAmfF_NaBihKkY+g@mail.gmail.com>
Organization: PostgreSQL
Content-Type: text/plain; charset="UTF-8"
Mime-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgsql-interfaces-owner@postgresql.org

> The following code compiles and runs fine without error messages on
> the Centos-6 box, but on the Centos-7 box, the execution of the
> prepared query with descriptor returns successful but without
> inserting any records and displaying the "No record actually
> inserted" message. Set PGUSER/PGDATABASE accordingly to run.

No idea why the same ecpg version behaves differently on these two
boxes. I assume that not both have the same version installed by
default, meaning you installed a non-default PostgreSQL yourself. Maybe
there was something left from the distro provided version?

> Any idea what I might be doing wrong?

Yes.

>     // Insert record
>     exec sql execute sid1 using descriptor insert_desc;

If my memory serves well, this should be "exec sql
execute sid1 using sql descriptor insert_desc;"

Without the SQL it tries to insert the sqlda which does not exist.=20

Michael
--=20
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=C3=A7a Bar=C3=A7a! SF 49ers! Use Debian GNU/Linux, Postgr=
eSQL


--=20
Sent via pgsql-interfaces mailing list (pgsql-interfaces@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-interfaces