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
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 |