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

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: t-ishii(at)sra(dot)co(dot)jp
Cc: hackers(at)postgreSQL(dot)org (PostgreSQL-development)
Subject: Re: [BUGS] NOTICE:AbortTransaction and not in in-progress state
Date: 1998-06-13 05:17:32
Message-ID: 199806130517.BAA15140@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 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(at)candle(dot)pha(dot)pa(dot)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)

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1998-06-13 05:22:56 Re: Odd behavior in regression test?
Previous Message Thomas G. Lockhart 1998-06-13 05:06:05 Odd behavior in regression test?