Thread: why can't see the updated value after SPI_execute("update ....", false, 1);

sunpeng <bluevaley@gmail.com> writes:
> First I use SPI_execute("update ....
>   bool succ;
>    SPI_connect();
>     int ret = SPI_execute("update ....where uid = 1", false, 1);//later will
> add error processing
>     if (ret == SPI_OK_UPDATE && SPI_processed == 1) {
>         succ = true;
>    }
>    SPI_finish();

> Then I use SPI_execute("select .....where uid = 1", ....

>     SPI_connect();
>     int ret = SPI_execute("select .....where uid = 1", true, 1);//later will
> add error processing
>     if (ret == SPI_OK_SELECT && SPI_processed == 1) {
>            HeapTuple tuple;
>            tuple = SPI_tuptable->vals[0];
>               ...
>            datum = heap_getattr(tuple,attrno,SPI_tuptable->tupdesc,&isnull);
>            ....
>     }
> the datum doesn't change, why ?

You're missing a CommandCounterIncrement() call between the two actions.
If you hadn't passed read_only = true to the second SPI_execute, it
would have done one for you.

            regards, tom lane