Re: [HACKERS] weird state after aborted transaction in pgsql 6.4
От
Hannu Krosing
Тема
Re: [HACKERS] weird state after aborted transaction in pgsql 6.4
Дата
Msg-id
36655625.2B8D80E0@trust.ee
Список
Дерево обсуждения
weird state after aborted transaction in pgsql 6.4 David Sauer <davids@iol.cz>
Re: [HACKERS] weird state after aborted transaction in pgsql 6.4 jwieck@debis.com (Jan Wieck)
Re: [HACKERS] weird state after aborted transaction in pgsql 6.4 Bruce Momjian <maillist@candle.pha.pa.us>
Jan Wieck wrote: > > The problem is, that the CREATE TABLE is inside the > transaction. So the catalog updates for the new table get > rolled back, but the file is still there. On the next CREATE > TABLE the file creation (made with O_EXCL) fails. > > You can safely remove the file .../data/base/david/tbl and > you should execute CREATE/DROP statements outside of > transactions. Is there any plans (in TODO) to fix this ? Either by making the CREATE/DROP totally ignore transactions (probably hard), ot then update the transaction machanism to be able to delete files created inside the transaction. -------------- Hannu
В списке pgsql-hackers по дате отправления
От: jwieck@debis.com (Jan Wieck)
Дата: