Bug #740: Temp tables not deleted if postmaster crashes

Поиск
Список
Период
Сортировка
От pgsql-bugs@postgresql.org
Тема Bug #740: Temp tables not deleted if postmaster crashes
Дата
Msg-id 20020817074917.3CABA47582E@postgresql.org
обсуждение исходный текст
Ответы Re: Bug #740: Temp tables not deleted if postmaster crashes  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: bug in config for cygwin
Следующее
От: "Scott"
Дата:
Сообщение: Re: bug in config for cygwin