Re: Transactions and temp tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Emmanuel Cecchet <manu(at)frogthinker(dot)org>
Cc: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Transactions and temp tables
Date: 2008-10-08 13:23:11
Message-ID: 28137.1223472191@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Emmanuel Cecchet <manu(at)frogthinker(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Merlin Moncure 2008-10-08 13:26:17 Re: WITH RECURSIVE ... CYCLE in vanilla SQL: issues with arrays of rows
Previous Message Simon Riggs 2008-10-08 13:23:06 pg_stop_backup wait bug fix