[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: [GENERAL] Trigger programming..
From: Tom Lane <tgl () sss ! pgh ! pa ! us>
Date: 2000-06-30 22:39:09
[Download RAW message or body]
"Mitch Vincent" <mitch@venux.net> 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
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic