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

Started by Bruce Momjianover 28 years ago1 messageshackers
Jump to latest
#1Bruce Momjian
bruce@momjian.us

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