Postgres Pro
Downloads
Home   >   mailing lists

Re: Transactions and temp tables - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Transactions and temp tables
Date
Msg-id 28137.1223472191@sss.pgh.pa.us
Whole thread Raw
In response to Re: Transactions and temp tables  (Emmanuel Cecchet <manu@frogthinker.org>)
Responses Re: Transactions and temp tables
List pgsql-hackers
Tree view 
Emmanuel Cecchet <manu@frogthinker.org> writes:
> Thanks for the example, I get it now. Does it make sense to allow any 
> request execution between PREPARE TRANSACTION and the subsequent COMMIT 
> or ROLLBACK?

Yes.  Don't even think of trying to disallow that.  The COMMIT doesn't
even have to happen in the same session, anyway.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: pg_stop_backup wait bug fix
Next
From: "Merlin Moncure"
Date:
Subject: Re: WITH RECURSIVE ... CYCLE in vanilla SQL: issues with arrays of rows