| From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> | 
|---|---|
| To: | hackers(at)postgreSQL(dot)org (PostgreSQL-development) | 
| Subject: | [BUGS] NOTICE:AbortTransaction and not in in-progress state (fwd) | 
| Date: | 1998-01-11 21:39:09 | 
| Message-ID: | 199801112139.QAA12792@candle.pha.pa.us | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-hackers | 
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(at)candle(dot)pha(dot)pa(dot)us
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1998-01-11 21:43:01 | [QUESTIONS] ORDER BY and nulls (fwd) | 
| Previous Message | Bruce Momjian | 1998-01-11 21:35:41 | Re: [BUGS] postgresql-6.1.1: wrong roll-back'ing "drop table" query. |