Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 3AB3564FC6F
	for <pgsql-hackers-postgresql.org@mail.postgresql.org>;
	Mon, 24 Nov 2008 19:24:05 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 57289-01
	for <pgsql-hackers-postgresql.org@mail.postgresql.org>;
	Mon, 24 Nov 2008 19:24:02 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from outbound-mail-153.bluehost.com (outbound-mail-153.bluehost.com
	[67.222.39.33])
	by mail.postgresql.org (Postfix) with SMTP id 15CD364FC44
	for <pgsql-hackers@postgresql.org>;
	Mon, 24 Nov 2008 19:24:01 -0400 (AST)
Received: (qmail 11738 invoked by uid 0); 24 Nov 2008 23:23:49 -0000
Received: from unknown (HELO fast22.fastdomain.com) (74.220.199.22)
	by outboundproxy5.bluehost.com with SMTP; 24 Nov 2008 23:23:49 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=default; d=frogthinker.org;
	h=Received:Message-ID:Date:From:Organization:User-Agent:MIME-Version:To:CC:Subject:References:In-Reply-To:Content-Type:Content-Transfer-Encoding:X-Identified-User;
	b=JZ2OdmrT0U8/vBmZAHoA+wkf5fY8EEEZjtl6nYtmB9aR+w0ZTpEqLStzv7wB5ccf0gVXtEvDd4Y2XO7mYxD9cz4/K0UF98kG8mSIxVQ3VgaB3oRJFvTqoNIYDWKWp3D6;
Received: from c-71-192-35-139.hsd1.ma.comcast.net ([71.192.35.139]
	helo=[192.168.0.13])
	by fast22.fastdomain.com with esmtpsa (TLSv1:AES256-SHA:256)
	(Exim 4.69) (envelope-from <manu@frogthinker.org>)
	id 1L4kmZ-0007ob-R8; Mon, 24 Nov 2008 16:23:57 -0700
Message-ID: <492B377F.4080602@frogthinker.org>
Date: Mon, 24 Nov 2008 18:23:43 -0500
From: Emmanuel Cecchet <manu@frogthinker.org>
Organization: Frog Thinker
User-Agent: Thunderbird 2.0.0.18 (Windows/20081105)
MIME-Version: 1.0
To: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
CC: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers@postgresql.org
Subject: Re: Transactions and temp tables
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>
In-Reply-To: <492543D5.9050904@enterprisedb.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Identified-User: {2846:fast22.fastdomain.com:frogthin:frogthinker.org}
	{sentby:smtp auth 71.192.35.139 authed with
	manu+frogthinker.org}
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200811/1601
X-Sequence-Number: 128313

Heikki,

The following test fails with your patch on my system. Could you check 
if you can reproduce?

psql (8.4devel)
Type "help" for help.

test=# begin;
BEGIN
test=# create table paul(x int);
CREATE TABLE
test=# insert into paul values(1);
INSERT 0 1
test=# prepare transaction 'persistentTableShouldSucceed';
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

---

LOG:  database system is ready to accept connections
TRAP: FailedAssertion("!(on_commits != ((void *)0))", File: 
"tablecmds.c", Line: 7823)
LOG:  server process (PID 15969) was terminated by signal 6: Aborted
LOG:  terminating any other active server processes
FATAL:  the database system is in recovery mode


Thanks,
manu