About the simple_heap_update function

Started by rupesh bajajover 18 years ago2 messages
#1rupesh bajaj
rupesh.bajaj@gmail.com

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: rupesh bajaj (#1)
Re: About the simple_heap_update function

"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