Обсуждение: 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