segmentation fault on Dynamic query using C

From: Priyank Raj <tanha(dot)raj(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: segmentation fault on Dynamic query using C
Date: 2009-01-22 06:10:22
Message-ID: 1b493db80901212210g4286465ag42ff00a2a730641c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I have a code(mention below), when i run this code on Intel machine it works
perfectly fine, but when i use AMD machine it giving me segmentation fault
at "EXEC SQL EXECUTE IMMEDIATE :qqq;" line. what could be the problem??

int main(int argc,char *argv[])
{

EXEC SQL BEGIN DECLARE SECTION;
const char *qqq = "insert into strands (id,filename,length,seq)
values(0,\'1\',2,\'{\"C\",\"A\"}\')";
char database[256],target[1024],host[256],user[256];
EXEC SQL END DECLARE SECTION;

exec sql whenever sqlerror sqlprint;

sprintf(target,"mydb(at)localhost");
ECPGdebug(1, stdout);

EXEC SQL CONNECT TO :target user priyank;

printf("1..\n");
EXEC SQL EXECUTE IMMEDIATE :qqq;
printf("2..\n");
EXEC SQL COMMIT;
printf("3..\n");

EXEC SQL DISCONNECT;
return 1;
}

i am using followinf command to make executable file

ecpg filename.pgc
gcc -Wall -o filename filename.o -lecpg -L/usr/local/pgsql/lib
-I/usr/local/pgsql/include -lcrypt

Thanks
Priyank Raj

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kent Tong 2009-01-22 08:02:24 error reading c:\Program Files\PostgreSQL\8.3\data\postgresql.conf during installation
Previous Message Oleg Serov 2009-01-21 11:57:14 Re: Bug in PL/PgSQL "SELECT .. INTO" statement parser