- Архив списков рассылки pgsql-sql

<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Hello.  I am trying to upgrade from PostgreSQL 8.0.3 to PostgreSQL 8.1.10.  I have a very simple
routinethat works fine with the 8.0.3 version:</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal" style="text-autospace:none"><font face="Courier New"
size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"">int easy_connect()</span></font><p class="MsoNormal"
style="text-autospace:none"><fontface="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier
New"">{</span></font><pclass="MsoNormal" style="text-indent:.5in;text-autospace:none"><font face="Courier New"
size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"">exec sql connect to my_db as my_cnxtn;</span></font><p
class="MsoNormal"style="text-indent:.5in;text-autospace:none"><font face="Courier New" size="2"><span
style="font-size:10.0pt;font-family:"CourierNew"">printf ("connection results:\n");</span></font><p class="MsoNormal"
style="text-indent:.5in;text-autospace:none"><fontface="Courier New" size="2"><span
style="font-size:10.0pt;font-family:"CourierNew"">printf ("code: %d\n", sqlca.sqlcode);</span></font><p
class="MsoNormal"style="text-indent:.5in;text-autospace:none"><font face="Courier New" size="2"><span
style="font-size:10.0pt;font-family:"CourierNew"">printf ("state: %s\n", sqlca.sqlstate);</span></font><p
class="MsoNormal"style="text-indent:.5in;text-autospace:none"><font face="Courier New" size="2"><span
style="font-size:10.0pt;font-family:"CourierNew"">printf ("warn: %s\n", sqlca.sqlwarn);</span></font><p
class="MsoNormal"style="text-indent:.5in;text-autospace:none"><font face="Courier New" size="2"><span
style="font-size:10.0pt;font-family:"CourierNew"">exec sql begin work;</span></font><p class="MsoNormal"
style="text-indent:.5in;text-autospace:none"><fontface="Courier New" size="2"><span
style="font-size:10.0pt;font-family:"CourierNew"">exec sql commit work;</span></font><p class="MsoNormal"
style="text-indent:.5in;text-autospace:none"><fontface="Courier New" size="2"><span
style="font-size:10.0pt;font-family:"CourierNew"">return 0;</span></font><p class="MsoNormal"
style="text-autospace:none"><fontface="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier
New"">}</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">When I use the 8.1.10 version, the connection works ( sqlca.sqlcode is 0, sqlca.sqlstate is 0000 and
sqlca.sqlwarnis blank).  But it then crashes on the “exec sql begin work” line.</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I get the following error in a window:</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal" style="text-indent:.5in"><font face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial">RuntimeError!</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal" style="text-indent:.5in"><font face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial">Program:C:\testSQL.exe</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal" style="text-indent:.5in"><font face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial">Thisapplication has requested the Runtime to terminate it in an unusual
way.</span></font><pclass="MsoNormal" style="text-indent:.5in"><font face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial">Pleasecontact the application’s support team for more
information.</span></font><pclass="MsoNormal" style="text-indent:.5in"><font face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial"> </span></font><pclass="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">I removed the 8.0.3 version using “remove program” from the control panel.  I then went and removed
myC:\Program Files\PostgreSQL\8.0 folder, just to make sure I was not including the wrong header files, linking to the
wronglibraries, or calling the wrong version of ecpg.exe.</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Thanks for any help.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">-Cheryl</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font></div>