The program below works with PostgreSQL 8.0.3, but not 8.1.10. The error I receive is:
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.
This happens on the “exec sql commit work” line. If I remove the comments, it works with 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 sometimes it will crash on the “exec sql begin work” line. The connection works fine -sqlca.sqlcode is 0, sqlca.sqlstate is 0000 and sqlca.sqlwarn is blank
I am running on WindowsXP and compiling with Visual C++ 6.0.
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.
Here’s the testSQL.pgc code:
/* add a comment */
/* and another */
/* one more */
main (int argc, char **argv)
{
printf ("connect\n");
exec sql connect to mdllt_db as mdllt_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;
printf ("begin results:\n");
printf ("code: %d\n", sqlca.sqlcode);
printf ("state: %s\n", sqlca.sqlstate);
printf ("warn: %s\n", sqlca.sqlwarn);
exec sql commit work;
printf ("end\n");
return 0;
}
Thanks for any help.
-Cheryl
