X-Original-To: pgsql-patches-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 2255E9FB224
	for <pgsql-patches-postgresql.org@postgresql.org>;
	Tue, 18 Jul 2006 13:14:08 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 43948-05-4 for
	<pgsql-patches-postgresql.org@postgresql.org>;
	Tue, 18 Jul 2006 13:13:52 -0300 (ADT)
X-Greylist: delayed 00:29:15.62176 by SQLgrey-
Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159])
	by postgresql.org (Postfix) with ESMTP id 5B2A99FB24A
	for <pgsql-patches@postgresql.org>;
	Tue, 18 Jul 2006 09:42:55 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3
Received: from vscan05.westnet.com.au (vscan05.westnet.com.au [203.10.1.139])
	by svr4.postgresql.org (Postfix) with ESMTP id 904D95AF026
	for <pgsql-patches@postgresql.org>;
	Tue, 18 Jul 2006 12:13:38 +0000 (GMT)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by localhost (Postfix) with ESMTP id 0898624A9D1;
	Tue, 18 Jul 2006 20:13:33 +0800 (WST)
Received: from vscan05.westnet.com.au ([127.0.0.1])
	by localhost (vscan05.westnet.com.au [127.0.0.1]) (amavisd-new,
	port 10024)
	with ESMTP id 1egDL+Im16Ro; Tue, 18 Jul 2006 20:13:32 +0800 (WST)
Received: from [202.72.133.22] (dsl-202-72-133-22.wa.westnet.com.au
	[202.72.133.22])
	by vscan05.westnet.com.au (Postfix) with ESMTP id 5539024A9CB;
	Tue, 18 Jul 2006 20:13:32 +0800 (WST)
Message-ID: <44BCD06C.3060409@calorieking.com>
Date: Tue, 18 Jul 2006 20:13:32 +0800
From: Christopher Kings-Lynne <chris.kings-lynne@calorieking.com>
User-Agent: Thunderbird 1.5.0.4 (Windows/20060516)
MIME-Version: 1.0
To: Joe Conway <mail@joeconway.com>
Cc: Andrew Dunstan <andrew@dunslane.net>, Bernd Helmle <mailings@oopsware.de>,
	Peter Eisentraut <peter_e@gmx.net>,
	"Patches (PostgreSQL)" <pgsql-patches@postgresql.org>,
	Susanne Ebrecht <susanne.ebrecht@credativ.de>
Subject: Re: [HACKERS] 8.2 features?
References: <44B69778.5050104@dunslane.net>
	<50461.84.63.113.55.1152832991.squirrel@pezone.net>
	<ECCAAC0A3182895D3D12B0E8@[172.26.14.247]>
	<44B7ADFC.90205@dunslane.net> <44BC0432.3040509@joeconway.com>
	<44BC661F.80609@joeconway.com>
In-Reply-To: <44BC661F.80609@joeconway.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200607/134
X-Sequence-Number: 20288

> The major downside is that somewhere between 9000 and 10000 
> VALUES-targetlists produces "ERROR:  stack depth limit exceeded". 
> Perhaps for the typical use-case this is sufficient though.
> 
> I'm open to better ideas, comments, objections...

If the use case is people running MySQL dumps, then there will be 
millions of values-targetlists in MySQL dumps.

Chris