Postgres Pro
Downloads
Home   >   mailing lists

why can't see the updated value after SPI_execute("update ....", false, 1); - Mailing list pgsql-general

From sunpeng
Subject why can't see the updated value after SPI_execute("update ....", false, 1);
Date
Msg-id AANLkTi=mkfGXmbbWLmRkL1wGbbMNqmSHQw0ht6TJKKvs@mail.gmail.com
Whole thread Raw
Responses Re: why can't see the updated value after SPI_execute("update ....", false, 1);  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
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 ?

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Incrementally Updated Backups
Next
From: Scott Marlowe
Date:
Subject: Re: How to inherit search_path from template