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.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======================================== jwieck(at)debis(dot)com (Jan Wieck) #