darcy@druid.net (D'Arcy J.M. Cain) writes:
> Get: 31930584, should be 3193058
> Get: 31943386, should be 3194338
> As you can see, there is an extra digit added. I am using PQoidStatus()
> to get the OID. Is this the right way? Is it possible that there is
> a buffer/terminating problem in the insert code?
Yes, on looking at it I see that someone broke PQoidStatus() in 7.0.
If you want to fix your copy, the patch (line numbers are for current
CVS) is
Index: fe-exec.c
===================================================================
RCS file: /home/projects/pgsql/cvsroot/pgsql/src/interfaces/libpq/fe-exec.c,v
retrieving revision 1.98
retrieving revision 1.100
diff -c -r1.98 -r1.100
*** fe-exec.c 2001/01/24 19:43:30 1.98
--- fe-exec.c 2001/02/06 02:02:27 1.100
***************
*** 2035,2041 **** if (len > 23) len = 23; strncpy(buf, res->cmdStatus + 7, len);
! buf[23] = '\0'; return buf; }
--- 2035,2041 ---- if (len > 23) len = 23; strncpy(buf, res->cmdStatus + 7, len);
! buf[len] = '\0'; return buf; }
However, really I'd recommend using PQoidValue() and not PQoidStatus()
at all.
regards, tom lane