Problem - Error: Cannot create table
От | Jens Niehaus |
---|---|
Тема | Problem - Error: Cannot create table |
Дата | |
Msg-id | 199903041607.RAA03201@c64.informatik.uni-dortmund.de обсуждение исходный текст |
Ответы |
doing SQL lookup to postgres from Foxpro
|
Список | 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
В списке pgsql-general по дате отправления: