Thread: About the simple_heap_update function
Hi,<br />I try to update a tuple in pg_attribute table by using the function simple_heap_update while somequery processingis going on. But when I use to see the value of that tuple(just updated) once again by SearchSysCache functionin the same query processing, I am not able to see the updated values. Can you please tell me what is the reason.Or what should i do to make the updation visible. <br /><br />Thanks,<br />Rupesh Bajaj<br />
"rupesh bajaj" <rupesh.bajaj@gmail.com> writes: > I try to update a tuple in pg_attribute table by using the function > simple_heap_update while somequery processing is going on. But when I use to > see the value of that tuple(just updated) once again by SearchSysCache > function in the same query processing, I am not able to see the updated > values. Can you please tell me what is the reason. Or what should i do to > make the updation visible. You'd need a CommandCounterIncrement() ... regards, tom lane