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)
Дата:
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] NT port
FAQ