About the simple_heap_update function
Hi,
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.
Thanks,
Rupesh Bajaj
"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