Re: Segmentation fault in 7.3 while vacuuming

I said:
> Frank van Vugt <ftm.van.vugt@foxi.nl> writes:
>> ** while using a client written in TrollTech's QT v3.1 that creates a number
>> of temporary tables, uses a number lot of 'copy' statements and at the end
>> tries to 'vacuum full analyse' the database

> Drat --- looks like the local buffer manager code has gotten out of sync
> with the relcache code.

Here is the fix if you need to patch this locally.

            regards, tom lane


*** 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 = RelationNodeCacheGetRelation(bufHdr->tag.rnode);

-         /*
-          * The relcache is not supposed to throw away temp rels, so this
-          * should always succeed.
-          */
-         Assert(bufrel != NULL);
-
          /* flush this page */
!         smgrwrite(DEFAULT_SMGR, bufrel, bufHdr->tag.blockNum,
!                   (char *) MAKE_PTR(bufHdr->data));
!         LocalBufferFlushCount++;

!         /* drop refcount incremented by RelationNodeCacheGetRelation */
!         RelationDecrementReferenceCount(bufrel);
      }

      /*
--- 90,113 ----
      {
          Relation    bufrel = RelationNodeCacheGetRelation(bufHdr->tag.rnode);

          /* flush this page */
!         if (bufrel == (Relation) NULL)
!         {
!             smgrblindwrt(DEFAULT_SMGR,
!                          bufHdr->tag.rnode,
!                          bufHdr->tag.blockNum,
!                          (char *) MAKE_PTR(bufHdr->data));
!         }
!         else
!         {
!             smgrwrite(DEFAULT_SMGR, bufrel,
!                       bufHdr->tag.blockNum,
!                       (char *) MAKE_PTR(bufHdr->data));
!             /* drop refcount incremented by RelationNodeCacheGetRelation */
!             RelationDecrementReferenceCount(bufrel);
!         }

!         LocalBufferFlushCount++;
      }

      /*