Re: Using host variables -- segmentation fault - Mailing list pgsql-novice

On Mon, Oct 16, 2006 at 05:16:06AM -0700, Yadnyesh Joshi wrote:
> The first EXEC SQL INSERT INTO simple values (6); executes fine. The
> value is added in the database as I am doing a COMMIT.
>
> However, segmentation fault occurs at EXEC SQL INSERT INTO simple values (:i);
> What can be the problem?

The program you posted doesn't initialize i but I'd expect that to
result in a garbage value being inserted instead of a segmentation
fault.  Do you still get a segmentation fault if you initialize i?
What about if you comment out the line that inserts i?

Initializing i doesn't make any difference. I still get a segmentation fault.
If I comment the line that inserts i, program executes fine. It runs to the comepletion.

Your program doesn't return a value from main().  I haven't worked
on any platforms where that would cause a segmentation fault but it
should be fixed in any case.

Return value is not a problem. If I add return 1; at the end, the problem persists.

What platform are you on?  What version of PostgreSQL?
PostgreSQL version - 8.1.5
I am working on Fedora Core 4 - 64 bit version.
Did you get a core dump?  If so, what does a stack trace show?
I didn't get core dump.

What do you see if you add "ECPGdebug(1, stderr);" at the beginning of the program?
[12328]: ECPGdebug: set to 1
[12328]: ECPGconnect: opening database mydb on localhost port <DEFAULT>
[12328]: got TSD connection
[12328]: ECPGexecute line 16: QUERY: insert into simple values( 6 ) on connection mydb
[12328]: ECPGexecute line 16 Ok: INSERT 0 1
[12328]: got TSD connection
[12328]: ECPGtrans line 17 action = commit connection = mydb
Before inserting i
[12328]: got TSD connection
Segmentation fault

I added a printf statement just before inserting into i.
For your refernce, here is first.pgc file again..

#include<stdio.h>
int main()
{
        EXEC SQL BEGIN DECLARE SECTION;
        char *target="mydb@localhost";
        int i;
        char msg[10];
        EXEC SQL END DECLARE SECTION;

        ECPGdebug(1, stderr);
        //strcpy(msg,"\'AAAA\'");
        i=9;

        EXEC SQL CONNECT TO :target;

        EXEC SQL INSERT INTO simple values (6);
        EXEC SQL COMMIT;
        printf("Before inserting i\n");
        EXEC SQL INSERT INTO simple values (:i);
        EXEC SQL COMMIT;

        //EXEC SQL INSERT INTO fromprg values (:i,:msg);
        //EXEC SQL COMMIT;

        EXEC SQL DISCONNECT;
        return 1;
}


Thanks,
Yadnyesh.




--
Michael Fuhr