View Single Post

   
  #8 (permalink)  
Old 04-11-2008, 05:07 AM
Tom Lane
 
Posts: n/a
Default Re: A 2 phase commit weirdness

Alvaro Herrera <alvherre@surnet.cl> writes:
> No, the ERROR is in a completely unrelated transaction. The scenario
> again is this:


> CREATE TABLE foo ();


> BEGIN;
> DROP TABLE foo;
> PREPARE TRANSACTION 'foo';



> SELECT * FROM foo;
> -- hangs
> COMMIT TRANSACTION 'foo';
> ERROR, relation deleted while still in
> use


Oh. Well, you get that now without any use of PREPARE; it's not clear
what else we could do, except possibly make the message a bit more
user-friendly.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply With Quote