Re: A 2 phase commit weirdness - Mailing list pgsql-hackers

From Tom Lane
Subject Re: A 2 phase commit weirdness
Date
Msg-id 12041.1117550698@sss.pgh.pa.us
Whole thread Raw
In response to Re: A 2 phase commit weirdness  (Alvaro Herrera <alvherre@surnet.cl>)
Responses Re: A 2 phase commit weirdness  (Alvaro Herrera <alvherre@surnet.cl>)
List pgsql-hackers
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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Barnali
Date:
Subject: ddl triggers
Next
From: Bruce Momjian
Date:
Subject: Re: Backslash handling in strings