From: | Michael Meskes <meskes(at)postgresql(dot)org> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Cc: | Anders Nilsson <anders(dot)nilsson(at)noaa(dot)gov> |
Subject: | Re: Inserting using SQL descriptors in ECPG in different versions of Linux |
Date: | 2017-10-01 08:44:23 |
Message-ID: | 1506847463.2588.50.camel@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
> 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.
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
From | Date | Subject | |
---|---|---|---|
Next Message | Anders Nilsson | 2017-10-02 14:14:05 | Re: Inserting using SQL descriptors in ECPG in different versions of Linux |
Previous Message | Anders Nilsson | 2017-09-28 18:14:39 | Inserting using SQL descriptors in ECPG in different versions of Linux |