Re: ECPG crash - upgrade from 8.0.3 to 8.1.10

<div class="Section1"><p class="MsoNormal"><font color="black" face="Arial" size="2"><span style="font-size:
10.0pt;font-family:Arial;color:black">The program below works with PostgreSQL 8.0.3, but not 8.1.10.  The error I
receiveis:</span></font><p class="MsoNormal"><font color="black" face="Arial" size="2"><span style="font-size: 
10.0pt;font-family:Arial;color:black"> </span></font><p class="MsoNormal" style="text-indent:.5in"><font color="black"
face="Arial"size="2"><span style="font-size:10.0pt;font-family:Arial;color:black">Runtime Error!</span></font><p
class="MsoNormal"><fontcolor="black" face="Arial" size="2"><span style="font-size: 
10.0pt;font-family:Arial;color:black"> </span></font><p class="MsoNormal" style="text-indent:.5in"><font color="black"
face="Arial"size="2"><span style="font-size:10.0pt;font-family:Arial;color:black">Program:
C:\testSQL.exe</span></font><pclass="MsoNormal"><font color="black" face="Arial" size="2"><span style="font-size: 
10.0pt;font-family:Arial;color:black"> </span></font><p class="MsoNormal" style="text-indent:.5in"><font color="black"
face="Arial"size="2"><span style="font-size:10.0pt;font-family:Arial;color:black">This application has requested the
Runtimeto terminate it in an unusual way.</span></font><p class="MsoNormal" style="text-indent:.5in"><font
color="black"face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:black">Please contact the
application’ssupport team for more information.</span></font><p class="MsoNormal"><font color="black" face="Arial"
size="2"><spanstyle="font-size: 
10.0pt;font-family:Arial;color:black"> </span></font><p class="MsoNormal"><font color="black" face="Arial"
size="2"><spanstyle="font-size: 
10.0pt;font-family:Arial;color:black">This happens on the “exec sql commit work” line.  If I remove the comments, it
workswith both 8.0.3 and 8.1.10.  If I change the comments (add a line, delete a line, etc.) it continues to crash, but
sometimesit will crash on the “exec sql begin work” line.  The connection works fine -</span></font><font
color="black"><spanstyle="color:black">sqlca.sqlcode is 0, sqlca.sqlstate is 0000 and sqlca.sqlwarn is
blank</span></font><fontcolor="black" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:black"></span></font><pclass="MsoNormal"><font color="black"
face="Arial"size="2"><span style="font-size: 
10.0pt;font-family:Arial;color:black"> </span></font><p class="MsoNormal"><font color="black" face="Arial"
size="2"><spanstyle="font-size: 
10.0pt;font-family:Arial;color:black">I am running on WindowsXP and compiling with Visual C++ 6.0.</span></font><p
class="MsoNormal"><fontcolor="black" face="Arial" size="2"><span style="font-size: 
10.0pt;font-family:Arial;color:black"> </span></font><p class="MsoNormal"><font color="black" face="Arial"
size="2"><spanstyle="font-size: 
10.0pt;font-family:Arial;color:black">I ran ecpg versions 8.0.3 and 8.1.10 on the file, then compared the created .c
files. According to KDiff, the files are identical, except for the first comment line saying which version of ecpg was
used.</span></font><pclass="MsoNormal"><font color="black" face="Arial" size="2"><span style="font-size: 
10.0pt;font-family:Arial;color:black"> </span></font><p class="MsoNormal"><font color="black" face="Arial"
size="2"><spanstyle="font-size: 
10.0pt;font-family:Arial;color:black">Here’s the testSQL.pgc code:</span></font><p class="MsoNormal"><font
color="black"face="Arial" size="2"><span style="font-size: 
10.0pt;font-family:Arial;color:black"> </span></font><p class="MsoNormal" style="text-autospace:none"><font
color="black"face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier New"; 
color:black">/* add a comment */</span></font><p class="MsoNormal" style="text-autospace:none"><font color="black"
face="CourierNew" size="2"><span style="font-size:10.0pt;font-family:"Courier New"; 
color:black"> </span></font><p class="MsoNormal" style="text-autospace:none"><font color="black" face="Courier New"
size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"; 
color:black">/* and another */</span></font><p class="MsoNormal" style="text-autospace:none"><font color="black"
face="CourierNew" size="2"><span style="font-size:10.0pt;font-family:"Courier New"; 
color:black"> </span></font><p class="MsoNormal" style="text-autospace:none"><font color="black" face="Courier New"
size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"; 
color:black">/* one more */</span></font><p class="MsoNormal" style="text-autospace:none"><font color="black"
face="CourierNew" size="2"><span style="font-size:10.0pt;font-family:"Courier New"; 
color:black"> </span></font><p class="MsoNormal" style="text-autospace:none"><font color="black" face="Courier New"
size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"; 
color:black">main (int argc, char **argv)</span></font><p class="MsoNormal" style="text-autospace:none"><font
color="black"face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier New"; 
color:black">{</span></font><p class="MsoNormal" style="text-autospace:none"><font color="black" face="Courier New"
size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"; 
color:black">      printf ("connect\n");</span></font><p class="MsoNormal" style="text-autospace:none"><font
color="black"face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier New"; 
color:black">      exec sql connect to mdllt_db as mdllt_cnxtn;</span></font><p class="MsoNormal"
style="text-autospace:none"><fontcolor="black" face="Courier New" size="2"><span
style="font-size:10.0pt;font-family:"CourierNew"; 
color:black">      printf ("connection results:\n");</span></font><p class="MsoNormal"
style="text-autospace:none"><fontcolor="black" face="Courier New" size="2"><span
style="font-size:10.0pt;font-family:"CourierNew"; 
color:black">      printf ("code: %d\n", sqlca.sqlcode);</span></font><p class="MsoNormal"
style="text-autospace:none"><fontcolor="black" face="Courier New" size="2"><span
style="font-size:10.0pt;font-family:"CourierNew"; 
color:black">      printf ("state: %s\n", sqlca.sqlstate);</span></font><p class="MsoNormal"
style="text-autospace:none"><fontcolor="black" face="Courier New" size="2"><span
style="font-size:10.0pt;font-family:"CourierNew"; 
color:black">      printf ("warn: %s\n", sqlca.sqlwarn);</span></font><p class="MsoNormal"
style="text-autospace:none"><fontcolor="black" face="Courier New" size="2"><span
style="font-size:10.0pt;font-family:"CourierNew"; 
color:black">      </span></font><p class="MsoNormal" style="text-autospace:none"><font color="black" face="Courier
New"size="2"><span style="font-size:10.0pt;font-family:"Courier New"; 
color:black">      exec sql begin work;</span></font><p class="MsoNormal" style="text-autospace:none"><font
color="black"face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier New"; 
color:black">      printf ("begin results:\n");</span></font><p class="MsoNormal" style="text-autospace:none"><font
color="black"face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier New"; 
color:black">      printf ("code: %d\n", sqlca.sqlcode);</span></font><p class="MsoNormal"
style="text-autospace:none"><fontcolor="black" face="Courier New" size="2"><span
style="font-size:10.0pt;font-family:"CourierNew"; 
color:black">      printf ("state: %s\n", sqlca.sqlstate);</span></font><p class="MsoNormal"
style="text-autospace:none"><fontcolor="black" face="Courier New" size="2"><span
style="font-size:10.0pt;font-family:"CourierNew"; 
color:black">      printf ("warn: %s\n", sqlca.sqlwarn);</span></font><p class="MsoNormal"
style="text-autospace:none"><fontcolor="black" face="Courier New" size="2"><span
style="font-size:10.0pt;font-family:"CourierNew"; 
color:black">      </span></font><p class="MsoNormal" style="text-autospace:none"><font color="black" face="Courier
New"size="2"><span style="font-size:10.0pt;font-family:"Courier New"; 
color:black">      exec sql commit work;</span></font><p class="MsoNormal" style="text-autospace:none"><font
color="black"face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier New"; 
color:black">      printf ("end\n");</span></font><p class="MsoNormal" style="text-autospace:none"><font color="black"
face="CourierNew" size="2"><span style="font-size:10.0pt;font-family:"Courier New"; 
color:black">      return 0;</span></font><p class="MsoNormal" style="text-autospace:none"><font color="black"
face="CourierNew" size="2"><span style="font-size:10.0pt;font-family:"Courier New"; 
color:black">}</span></font><p class="MsoNormal" style="text-autospace:none"><font color="black" face="Courier New"
size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"; 
color:black"> </span></font><p class="MsoNormal" style="text-autospace:none"><font color="black" face="Courier New"
size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"; 
color:black">Thanks for any help.</span></font><p class="MsoNormal" style="text-autospace:none"><font color="black"
face="CourierNew" size="2"><span style="font-size:10.0pt;font-family:"Courier New"; 
color:black">-Cheryl</span></font><p class="MsoNormal" style="text-autospace:none"><font color="black" face="Courier
New"size="2"><span style="font-size:10.0pt;font-family:"Courier New"; 
color:black"> </span></font><p class="MsoNormal"><font color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black"> </span></font></div>