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" ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster