Problem - Error: Cannot create table

From: Jens Niehaus <niehaus(at)c64(dot)informatik(dot)uni-dortmund(dot)de>
To: pgsql-general(at)postgresql(dot)org
Cc: niehaus(at)c64(dot)informatik(dot)uni-dortmund(dot)de
Subject: Problem - Error: Cannot create table
Date: 1999-03-04 16:07:55
Message-ID: 199903041607.RAA03201@c64.informatik.uni-dortmund.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message William J. Stotts 1999-03-04 17:04:05 doing SQL lookup to postgres from Foxpro
Previous Message Pavel PaJaSoft Janousek 1999-03-04 16:01:05 ECPG & 'exec sql connect to' question