Re: A 2 phase commit weirdness

On Tue, May 31, 2005 at 10:44:58AM -0400, Tom Lane wrote:
> 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.

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)