Re: [HACKERS] weird state after aborted transaction in pgsql 6.4

> >
> > My database is in weird state after some operation. Here is an example:
> >
> > [david(at)kerberos david]$ psql
> > .....
> > david=> begin;
> > BEGIN
> > david=> create table tbl ( i int );
> > CREATE
> > david=> insert into tbl values(1);
> > INSERT 104137 1
> > EOFid=> [<ctrl-d> here]
> > [david(at)kerberos david]$ psql
> > ....
> > david=> create table tbl ( a text );
> > ERROR: cannot create tbl
> > david=> \d
> > Couldn't find any tables, sequences or indices!
> > ====================== cut here ======================
> > Simple question: why 'ERROR: cannot create tbl' ?
> > Platform: linux i586, glibc, regression tests seems ok (except minor
> > problem with floating point. The some problem have my colleague.
>
> 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.
>

Added to TODO:

* CREATE TABLE inside aborted transaction causes stray table file

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026