Thread: problem with cache

problem with cache

From
ivan
Date:
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 ?


Re: problem with cache

From
Alvaro Herrera
Date:
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"


Re: problem with cache

From
ivan
Date:
drop relation = drop table or drop sequence etc
I tryed RelationForgetRelation() but i dont working :(

On Mon, 4 Aug 2003, Alvaro Herrera wrote:

> 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"
>