Обсуждение: [BUGS] NOTICE:AbortTransaction and not in in-progress state (fwd)

Поиск
Список
Период
Сортировка

[BUGS] NOTICE:AbortTransaction and not in in-progress state (fwd)

От
Bruce Momjian
Дата:
Can someone figure out why this is happening?


Forwarded message:
> ------------------------------------------------
> Dropping table after aborting a transanction makes PosgresSQL unsable.
>
>
> Please describe a way to repeat the problem.   Please try to provide a
> concise reproducible example, if at all possible:
> ----------------------------------------------------------------------
> [srashd]t-ishii{67} psql -e test < b
> QUERY: drop table test;
> WARN:Relation test Does Not Exist!
> QUERY: create table test (i int4);
> QUERY: create index iindex on test using btree(i);
> QUERY: begin;
> QUERY: insert into test values (100);
> QUERY: select * from test;
>   i
> ---
> 100
> (1 row)
>
> QUERY: rollback;
> QUERY: drop table test;
> NOTICE:AbortTransaction and not in in-progress state
> NOTICE:AbortTransaction and not in in-progress state
>
> Note that if I do not make an index, it would be ok.
>
> If you know how this problem might be fixed, list the solution below:
> ---------------------------------------------------------------------
>
>


--
Bruce Momjian
maillist@candle.pha.pa.us