Re: [HACKERS] weird state after aborted transaction in pgsql 6.4 - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: [HACKERS] weird state after aborted transaction in pgsql 6.4
Date
Msg-id 36655625.2B8D80E0@trust.ee
Whole thread Raw
In response to Re: [HACKERS] weird state after aborted transaction in pgsql 6.4  (jwieck@debis.com (Jan Wieck))
List pgsql-hackers
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 by date:

Previous
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Re: [HACKERS] weird state after aborted transaction in pgsql 6.4
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] NT port