Re: A 2 phase commit weirdness

On Tue, May 31, 2005 at 10:44:58AM -0400, Tom Lane wrote:
> Alvaro Herrera <alvherre(at)surnet(dot)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.

Ah, you are right, sorry :-) I was imagining I had to cope with that
but evidently not.

--
Alvaro Herrera (<alvherre[a]surnet.cl>)
"Granting software the freedom to evolve guarantees only different results,
not better ones." (Zygo Blaxell)