Thread: upgrade from 8.0.3 to 8.1.10 crash

upgrade from 8.0.3 to 8.1.10 crash

From
"Boergesson, Cheryl"
Date:
<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.  <font color="navy"><span
style="color:navy">I’mon WindowsXP and I’m compiling with Visual C++ 6.0.</span></font></span></font><p
class="MsoNormal"><fontcolor="navy" face="Arial" size="2"><span style="font-size: 
10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">I have a very simple routine that works fine with the 8.0.3 version:</span></font><p
class="MsoNormal"><fontface="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>

Re: upgrade from 8.0.3 to 8.1.10 crash

From
"Boergesson, Cheryl"
Date:

I found when I removed all comments, it worked fine.  Any ideas?

 


From: pgsql-hackers-owner@postgresql.org [mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Boergesson, Cheryl
Sent: Thursday, October 18, 2007 9:24 AM
To: pgsql-hackers@postgresql.org
Subject: [HACKERS] upgrade from 8.0.3 to 8.1.10 crash

 

Hello.  I am trying to upgrade from PostgreSQL 8.0.3 to PostgreSQL 8.1.10.  I’m on WindowsXP and I’m compiling with Visual C++ 6.0.

 

I have a very simple routine that works fine with the 8.0.3 version:

 

int easy_connect()

{

exec sql connect to my_db as my_cnxtn;

printf ("connection results:\n");

printf ("code: %d\n", sqlca.sqlcode);

printf ("state: %s\n", sqlca.sqlstate);

printf ("warn: %s\n", sqlca.sqlwarn);

exec sql begin work;

exec sql commit work;

return 0;

}

 

When I use the 8.1.10 version, the connection works ( sqlca.sqlcode is 0, sqlca.sqlstate is 0000 and sqlca.sqlwarn is blank).  But it then crashes on the “exec sql begin work” line.

 

I get the following error in a window:

 

Runtime Error!

 

Program: C:\testSQL.exe

 

This application has requested the Runtime to terminate it in an unusual way.

Please contact the application’s support team for more information.

 

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 was not including the wrong header files, linking to the wrong libraries, or calling the wrong version of ecpg.exe.

 

Thanks for any help.

-Cheryl

 

Re: upgrade from 8.0.3 to 8.1.10 crash

From
Alvaro Herrera
Date:
Boergesson, Cheryl wrote:
> I found when I removed all comments, it worked fine.  Any ideas?

I suggest you add "ECPG" to the subject line so that the relevant
developers notice your problem.


-- 
Alvaro Herrera                 http://www.amazon.com/gp/registry/CTMLCN8V17R4
"The Postgresql hackers have what I call a "NASA space shot" mentality.Quite refreshing in a world of "weekend drag
racer"developers."
 
(Scott Marlowe)


ECPG crash - upgrade from 8.0.3 to 8.1.10

From
"Boergesson, Cheryl"
Date:
<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>

Re: upgrade from 8.0.3 to 8.1.10 crash

From
Tom Lane
Date:
"Boergesson, Cheryl" <Cheryl.Boergesson@gdit.com> writes:
> I found when I removed all comments, it worked fine.  Any ideas?

Oh?  Considering that the fragments you've shown us have never had
one single comment, that means that no one could possibly have offered
you any useful advice.

Please, if you would like help with this sort of problem, show a complete
self-contained test case.  Leaving stuff out is counterproductive, way
too often.
        regards, tom lane


Re: ECPG crash - upgrade from 8.0.3 to 8.1.10

From
Michael Meskes
Date:
On Thu, Oct 18, 2007 at 03:36:34PM -0400, Boergesson, Cheryl wrote:
> Hello.  I am trying to upgrade from PostgreSQL 8.0.3 to PostgreSQL
> 8.1.10.  I'm on WindowsXP and I'm compiling with Visual C++ 6.0.
> ...
> Oddly, when I removed all comments, it worked fine.

Which comments?

Michael
-- 
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!


Re: ECPG crash - upgrade from 8.0.3 to 8.1.10

From
"Boergesson, Cheryl"
Date:
<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>

Re: ECPG crash - upgrade from 8.0.3 to 8.1.10

From
Michael Meskes
Date:
On Mon, Oct 22, 2007 at 10:07:03AM -0400, Boergesson, Cheryl wrote:
> The program below works with PostgreSQL 8.0.3, but not 8.1.10.  The
> error I receive is:
> ...

Is there a way for you to compile and run the program without threading?
Or try with CVS head instead of 8.1.10?

Michael
-- 
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!