Re: Segmentation fault in 7.3 while vacuuming - Mailing list pgsql-general

From Tom Lane
Subject Re: Segmentation fault in 7.3 while vacuuming
Date
Msg-id 25261.1039098808@sss.pgh.pa.us
Whole thread Raw
In response to Re: Segmentation fault in 7.3 while vacuuming  (Frank van Vugt <ftm.van.vugt@foxi.nl>)
Responses Re: Segmentation fault in 7.3 while vacuuming  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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.  In particular I note the following in localbuf.c

        Relation    bufrel = RelationNodeCacheGetRelation(bufHdr->tag.rnode);

        /*
         * The relcache is not supposed to throw away temp rels, so this
         * should always succeed.
         */
        Assert(bufrel != NULL);

which was true at the time it was written, but is so no longer :-(

Will fix.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [ODBC] Drop column and Access
Next
From: Matthew Gabeler-Lee
Date:
Subject: Re: Query breaking with unknown expression type (lost s