problem with cache
hi, i have more problems with cache :( i wrote about it latter , but there
was no answer. Because when i drop same relation its should be clean cache
too, but postgres dont do it . Ist sad because i cant do reload db , i
have errors :( what should i do ?
On Mon, Aug 04, 2003 at 09:24:49PM +0200, ivan wrote:
hi, i have more problems with cache :( i wrote about it latter , but there
was no answer. Because when i drop same relation its should be clean cache
too, but postgres dont do it . Ist sad because i cant do reload db , i
have errors :( what should i do ?
What do you mean by "drop same relation"? Is this SQL or you are
hacking the backend? If the latter maybe you need something like
RelationFlushBuffers() or RelationForgetRelation().
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"The ability to monopolize a planet is insignificant
next to the power of the source"
drop relation = drop table or drop sequence etc
I tryed RelationForgetRelation() but i dont working :(
On Mon, 4 Aug 2003, Alvaro Herrera wrote:
Show quoted text
On Mon, Aug 04, 2003 at 09:24:49PM +0200, ivan wrote:
hi, i have more problems with cache :( i wrote about it latter , but there
was no answer. Because when i drop same relation its should be clean cache
too, but postgres dont do it . Ist sad because i cant do reload db , i
have errors :( what should i do ?What do you mean by "drop same relation"? Is this SQL or you are
hacking the backend? If the latter maybe you need something like
RelationFlushBuffers() or RelationForgetRelation().--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"The ability to monopolize a planet is insignificant
next to the power of the source"