Thread: Re: [BUGS] NOTICE:AbortTransaction and not in in-progress state

Re: [BUGS] NOTICE:AbortTransaction and not in in-progress state

From
Bruce Momjian
Date:
> Please enter a FULL description of your problem:
> ------------------------------------------------
> 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.

Can someone comment on the cause of the above problem?  Is it a bug to
add to the TODO list?  I have verified it still exists in the current
sources.


--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)