Oh, I'm so sorry....
I've made a stupid mistake... and this mistake is at the cost of 3 days
work.
The segmentation fault is totally irrelevant to the time functions in
previous thread.
Buggy Code Fragment FYI
--8<------------------------
..
.. len =strlen(PQgetvalue(res, 0, i)) * 2 + 1; // <========= printf("***********length=%d\n", len); tmp2 = (char *)
calloc(sizeof(char),len); strcat(p2, "'");
PQescapeString(tmp2, PQgetvalue(res, 0, i), len); // <========= this
line, // PQescapeString won't stop at '\0', so it will go out // of range of the returning value by PQgetvalue().
strcat(p2, tmp2); strcat(p2, "', "); free(tmp2); tmp2 = NULL;
..
..
---------->8--------------
Here I have one more question, is there any debugging tools other than GDB?
I'm not quite used to it, debugging segmentation fault is really a pain. :-(
Thx,
Frankie Lam
"Frankie Lam" <frankie@ucr.com.hk> wrote in message
news:b6gku9$2llu$1@news.hub.org...
> Hi,
>
> I want to ask what does the error message mean by
> "0x40023abb in resetPQExpBuffer () from /usr/local/pgsql/lib/libpq.so.3"?
> I got this message using GDB to trace the program.
> (Segmentation fault occurswhen run the program directly.)
>
> I reviewed the program many times, and found this is only to happen when
> I call the `ctime()' or `time()' in a program function.
>
> code fragment FYI
> --8<------------------------
> // `res = PQexec(conn, sql)' here..
> ...
> ...
> }
> else if (!strcmp(PQfname(res, i), SYNCTIME_FIELD_NAME))
> {
> // puts("7");
> //char chP[30];
> printf("timer=%ld\n", time(timer)); // <====== without this line, the
> program works
> // printf("%s", ctime(time(NULL)));
> // printf("%s", asctime(localtime(&timer)));
> sprintf(tmp, "'1999-12-11 09:50:58'::timestamp, ");
> strcat(p2, tmp);
> }
> else if (!strcmp(PQfname(res, i), SERVERID_FIELD_NAME))
> {
> puts("8");
> sprintf(tmp, "'%s'", PQgetvalue(res, 0, i));
> strcat(p2, tmp);
> }
> }
> ...
> ...
> freeing resources here
> ---------->8--------------
>
> Thank you very much.
>
> Frankie Lam.
>
>
