> after I upgrade my postgresql from 7.2 to 7.3, one query always makes ser=
ver
> terminated
This is caused by the vacuum of a temp table.
Tom fixed it already about a week ago and provided the patch here:
*** src/backend/storage/buffer/localbuf.c.orig Wed Sep 4 16:31:25 2002
--- src/backend/storage/buffer/localbuf.c Thu Dec 5 17:48:10 2002
***************
*** 90,108 ****
{
Relation bufrel =3D=20
RelationNodeCacheGetRelation(bufHdr->tag.rnode);
=20=20
- /*
- * The relcache is not supposed to throw away temp rels, so=
=20
this
- * should always succeed.
- */
- Assert(bufrel !=3D NULL);
-=20
/* flush this page */
! smgrwrite(DEFAULT_SMGR, bufrel, bufHdr->tag.blockNum,
! (char *) MAKE_PTR(bufHdr->data));
! LocalBufferFlushCount++;
=20=20
! /* drop refcount incremented by RelationNodeCacheGetRelatio=
n=20
*/
! RelationDecrementReferenceCount(bufrel);
}
=20=20
/*
--- 90,113 ----
{
Relation bufrel =3D=20
RelationNodeCacheGetRelation(bufHdr->tag.rnode);
=20=20
/* flush this page */
! if (bufrel =3D=3D (Relation) NULL)
! {
! smgrblindwrt(DEFAULT_SMGR,
! bufHdr->tag.rnode,
! bufHdr->tag.blockNum,
! (char *)=20
MAKE_PTR(bufHdr->data));
! }
! else
! {
! smgrwrite(DEFAULT_SMGR, bufrel,
! bufHdr->tag.blockNum,
! (char *) MAKE_PTR(bufHdr->data));
! /* drop refcount incremented by=20
RelationNodeCacheGetRelation */
! RelationDecrementReferenceCount(bufrel);
! }
=20=20
! LocalBufferFlushCount++;
}
=20=20
/*
Regards,
Frank.