Re: A 2 phase commit weirdness

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)surnet(dot)cl>
Cc: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: A 2 phase commit weirdness
Date: 2005-05-31 14:44:58
Message-ID: 12041.1117550698@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2005-05-31 14:53:08 Re: Cost of XLogInsert CRC calculations
Previous Message Tom Lane 2005-05-31 14:41:21 Re: Fix for cross compilation