Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



sunpeng <bluevaley@xxxxxxxxx> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux