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