Bug #740: Temp tables not deleted if postmaster crashes - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Bug #740: Temp tables not deleted if postmaster crashes
Date
Msg-id 20020817074917.3CABA47582E@postgresql.org
Whole thread Raw
Responses Re: Bug #740: Temp tables not deleted if postmaster crashes  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Philip Warner (pjw@rhyme.com.au) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
Temp tables not deleted if postmaster crashes

Long Description
If a postmaster crashes then any temporary tables associated with the backend will not be deleted, which is logical
thoughsad. However, when the database is next started, it does not clean up the leftover temp tables. 

'drop table pg_temp_NNNNN_N' seems to work, but it seems more reasonable to expect the startup process to cleanup dead
tables.


Sample Code


No file was uploaded with this report

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: bug in config for cygwin
Next
From: "Scott"
Date:
Subject: Re: bug in config for cygwin