Postgres Pro
Downloads
Home   >   mailing lists

Re: Locks on temp table and PREPARE - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Locks on temp table and PREPARE
Date
Msg-id 25480.1244064783@sss.pgh.pa.us
Whole thread Raw
In response to Re: Locks on temp table and PREPARE  (Emmanuel Cecchet <manu@frogthinker.org>)
Responses Re: Locks on temp table and PREPARE  (Emmanuel Cecchet <manu@frogthinker.org>)
List pgsql-hackers
Tree view 
Emmanuel Cecchet <manu@frogthinker.org> writes:
> But when the transaction prepares, we know that. What would prevent us 
> to do at prepare time the same cleanup that commit does?

The entire point of PREPARE is that it's *not* committed yet.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Emmanuel Cecchet
Date:
Subject: Re: Locks on temp table and PREPARE
Next
From: Tatsuo Ishii
Date:
Subject: Re: 8.4b2 tsearch2 strange error