On Tue, May 31, 2005 at 10:44:58AM -0400, Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> 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) ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
