ECPG crash - upgrade from 8.0.3 to 8.1.10 - Mailing list pgsql-hackers

<div class="Section1"><p class="MsoNormal"><font color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black">Hello. I am trying to upgrade from PostgreSQL 8.0.3 to PostgreSQL 8.1.10.  I’m on
WindowsXPand I’m compiling with Visual C++ 6.0.</span></font><p class="MsoNormal"><font color="black" face="Times New
Roman"size="3"><span style="font-size:12.0pt;color:black"> </span></font><p class="MsoNormal"><font color="black"
face="TimesNew Roman" size="3"><span style="font-size:12.0pt;color:black">I have a very simple routine that works fine
withthe 8.0.3 version:</span></font><p class="MsoNormal"><font color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black"> </span></font><pclass="MsoNormal" style="text-autospace:none"><font color="black"
face="TimesNew Roman" size="3"><span style="font-size:12.0pt;color:black">int easy_connect()</span></font><p
class="MsoNormal"style="text-autospace:none"><font color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black">{</span></font><pclass="MsoNormal"
style="text-indent:.5in;text-autospace:none"><fontcolor="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black">execsql connect to my_db as my_cnxtn;</span></font><p class="MsoNormal"
style="text-indent:.5in;text-autospace:none"><fontcolor="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black">printf("connection results:\n");</span></font><p class="MsoNormal"
style="text-indent:.5in;text-autospace:none"><fontcolor="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black">printf("code: %d\n", sqlca.sqlcode);</span></font><p class="MsoNormal"
style="text-indent:.5in;text-autospace:none"><fontcolor="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black">printf("state: %s\n", sqlca.sqlstate);</span></font><p class="MsoNormal"
style="text-indent:.5in;text-autospace:none"><fontcolor="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black">printf("warn: %s\n", sqlca.sqlwarn);</span></font><p class="MsoNormal"
style="text-indent:.5in;text-autospace:none"><fontcolor="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black">execsql begin work;</span></font><p class="MsoNormal"
style="text-indent:.5in;text-autospace:none"><fontcolor="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black">execsql commit work;</span></font><p class="MsoNormal"
style="text-indent:.5in;text-autospace:none"><fontcolor="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black">return0;</span></font><p class="MsoNormal" style="text-autospace:none"><font
color="black"face="Times New Roman" size="3"><span style="font-size:12.0pt;color:black">}</span></font><p
class="MsoNormal"><fontcolor="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black"> </span></font><pclass="MsoNormal"><font color="black" face="Times New Roman"
size="3"><spanstyle="font-size:12.0pt;color:black">When I use the 8.1.10 version, the connection works ( sqlca.sqlcode
is0, sqlca.sqlstate is 0000 and sqlca.sqlwarn is blank).  But it then crashes on the “exec sql begin work”
line.</span></font><pclass="MsoNormal"><font color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black"> </span></font><pclass="MsoNormal"><font color="black" face="Times New Roman"
size="3"><spanstyle="font-size:12.0pt;color:black">I get the following error in a window:</span></font><p
class="MsoNormal"><fontcolor="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black"> </span></font><pclass="MsoNormal" style="text-indent:.5in"><font color="black"
face="TimesNew Roman" size="3"><span style="font-size:12.0pt;color:black">Runtime Error!</span></font><p
class="MsoNormal"><fontcolor="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black"> </span></font><pclass="MsoNormal" style="text-indent:.5in"><font color="black"
face="TimesNew Roman" size="3"><span style="font-size:12.0pt;color:black">Program: C:\testSQL.exe</span></font><p
class="MsoNormal"><fontcolor="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black"> </span></font><pclass="MsoNormal" style="text-indent:.5in"><font color="black"
face="TimesNew Roman" size="3"><span style="font-size:12.0pt;color:black">This application has requested the Runtime to
terminateit in an unusual way.</span></font><p class="MsoNormal" style="text-indent:.5in"><font color="black"
face="TimesNew Roman" size="3"><span style="font-size:12.0pt;color:black">Please contact the application’s support team
formore information.</span></font><p class="MsoNormal" style="text-indent:.5in"><font color="black" face="Times New
Roman"size="3"><span style="font-size:12.0pt;color:black"> </span></font><p class="MsoNormal"><font color="black"
face="TimesNew Roman" size="3"><span style="font-size:12.0pt;color:black">I removed the 8.0.3 version using “remove
program”from the control panel.  I then went and removed my C:\Program Files\PostgreSQL\8.0 folder, just to make sure I
wasnot including the wrong header files, linking to the wrong libraries, or calling the wrong version of
ecpg.exe.</span></font><pclass="MsoNormal"><font color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black"> </span></font><pclass="MsoNormal"><font color="black" face="Times New Roman"
size="3"><spanstyle="font-size:12.0pt;color:black">Oddly, when I removed all comments, it worked fine.</span></font><p
class="MsoNormal"><fontcolor="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black"> </span></font><pclass="MsoNormal"><font color="black" face="Times New Roman"
size="3"><spanstyle="font-size:12.0pt;color:black">Thanks for any help.</span></font><p class="MsoNormal"><font
color="black"face="Times New Roman" size="3"><span style="font-size:12.0pt;color:black">-Cheryl</span></font><p
class="MsoNormal"><fontcolor="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black"> </span></font></div>