Bug #740: Temp tables not deleted if postmaster crashes

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 though sad. 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