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); }
elseif (!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.