Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group