Hello,
i've problems creating a table which was already created in an earlier
transaction which crashed before completion (PostgreSQL 6.4.0, linux 2.0.36,
libc-5.4):
>postgres:> psql example
>[...]
>example=> BEGIN TRANSACTION;
>BEGIN
>example=> CREATE TABLE corrupt (name int4);
>CREATE
now the psql-process receives a SIGKILL from somewhere else
>postgres:> ps |grep psql
1234 p5 S 0:00 psql example
>postgres:> kill -9 1234
this results in
>example=> Killed
When I try to create the table again:
>postgres:> psql example
>[...]
>example=> BEGIN TRANSACTION;
>BEGIN
>example=> CREATE TABLE corrupt (name int4);
>ERROR: cannot create corrupt
>beispiel=> END TRANSACTION;
>END
>example=> DROP TABLE CORRUPT;
>ERROR: Relation corrupt Does Not Exist!
The same thing happens when i try somthing like 'PQexec(conn,"BEGIN");PQexec(co
nn,"CREATE...");exit(1);' with libpq.
Is there a way to fix it and to create the table again?
Thanks,
Jens
