"Mitch Vincent" <[EMAIL PROTECTED]> writes: > I have this code... > tupdesc = rel->rd_att; /* what the tuple looks like (?) */ > app_id_colnum = SPI_fnumber(tupdesc, app_id_fieldname); > if (app_id_colnum == SPI_ERROR_NOATTRIBUTE) > elog(ERROR, "app_id_colnum - SPI_ERROR_NOATTRIBUTE error "); > char_app_id = SPI_getvalue(rettuple, tupdesc, app_id_colnum); Looks OK to me, as far as it goes. I'd wonder whether the tuple actually matches the tupdesc you're using. Looking at SPI_getvalue itself (in src/backend/executor/spi.c), I can see that SPI_result might offer a clue about why it's failing. regards, tom lane