pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Emmanuel Cecchet <manu@frogthinker.org>
To: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Transactions and temp tables
Date: Mon, 08 Dec 2008 14:47:12 -0500
Message-ID: <493D79C0.7080405@frogthinker.org> (raw)
In-Reply-To: <49364AFB.5060404@enterprisedb.com>
References: <48EA7B12.6050906@frogthinker.org>
	<48EB0551.50205@enterprisedb.com>
	<48EB95B7.10604@frogthinker.org>
	<48EC7EB5.5020001@enterprisedb.com>
	<48ECAA8F.3070306@frogthinker.org>
	<28137.1223472191@sss.pgh.pa.us>
	<48ECBBC2.6060003@frogthinker.org>
	<29132.1223475486@sss.pgh.pa.us>
	<48EFA13C.2060407@frogthinker.org>
	<490F804A.60108@enterprisedb.com>
	<490FB4B3.908@frogthinker.org>
	<49106B10.2090407@enterprisedb.com>
	<4910DFC0.3080301@frogthinker.org>
	<4914CD14.2060608@frogthinker.org>
	<4921C42A.3030600@enterprisedb.com>
	<492221A3.1060608@frogthinker.org>
	<4922A798.7050709@enterprisedb.com>
	<49232993.1050801@enterprisedb.com>
	<49243376.2000404@frogthinker.org>
	<492543D5.9050904@enterprisedb.com>
	<492B377F.4080602@frogthinker.org>
	<49344E22.2000008@frogthinker.org>
	<4934A4E0.8080208@frogthinker.org>
	<49364AFB.5060404@enterprisedb.com>

Hi all,

Here is a new version of the patch still based on the last proposal by 
Heikki.
This patch only support temp tables that are created AND dropped in the 
same transaction. This works with any kind of temp table (with on commit 
options or not).
This simplifies the problem since the temp tables we consider here 
cannot be accessed by another backend anyway since their scope is the 
one of the transaction.
We do NOT allow:
- access to temp tables that were not created AND dropped in the transaction
- created temp tables that are not dropped at prepare time
- dropped temp tables that were not created in the transaction

The attached patch has a number of tests for all these cases including 
sequences and index on temp tables.

Let me know what you think
Emmanuel

-- 
Emmanuel Cecchet
FTO @ Frog Thinker 
Open Source Development & Consulting
--
Web: http://www.frogthinker.org
email: manu@frogthinker.org
Skype: emmanuel_cecchet

Attachments:

  patch-2pc-temp-table-8.4v6-create_drop_only-withtests.zip (application/octet-stream, 9.7K) download

view thread (36+ messages)

Message-ID: <493D79C0.7080405@frogthinker.org>
Permalink:  ../493D79C0.7080405@frogthinker.org/
Also on:    postgresql.org/message-id/493D79C0.7080405@frogthinker.org

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: manu@frogthinker.org, heikki.linnakangas@enterprisedb.com, tgl@sss.pgh.pa.us
  Subject: Re: Transactions and temp tables
  In-Reply-To: <493D79C0.7080405@frogthinker.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox