|
> 1) What is your exact Postgres version i.e 8.1.5.?
V - 8.1.18 > 3) You also say it works fine in two environments, but not one. > > What are the environments? > OS and version, memory, Postgres versions, etc. It is working on most of the production system ( more than 100) but failed once in one of the system ( not always). > OS and version, memory, Postgres versions, etc. RHEL 5.2 , 32 GB , 8.1.18 >Current value in colname = 5; > Update tablename set colname = 0 where key = 18; > commit , in parallel to above queries ( either vacuum or reindex of > table was running) > > After 10 sec following query is executed. > select colname from tablename where key = 18 ;it is returning old value > i.e colname = 5. > After another few seconds select colname from tablename where key = 18 > ;it is returning new value i.e colname = 0. > > You say at the top the new value is 0, but show 5 as the new value at > the bottom. > Sorry it is returning new value ie 0 after some time. Corrected the above description. |
