X-Original-To: pgsql-patches-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 1C2369F95E3 for ; Tue, 18 Jul 2006 16:04:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 68686-01 for ; Tue, 18 Jul 2006 19:04:05 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id C4A939F94F3 for ; Tue, 18 Jul 2006 16:04:05 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id B53C430B72; Tue, 18 Jul 2006 21:04:03 +0200 (MET DST) From: Chris Browne X-Newsgroups: pgsql.patches Subject: Re: [HACKERS] 8.2 features? Date: Tue, 18 Jul 2006 14:49:35 -0400 Organization: cbbrowne Computing Inc Lines: 19 Message-ID: <60u05eagu8.fsf@dba2.int.libertyrms.com> References: <44B69778.5050104@dunslane.net> <50461.84.63.113.55.1152832991.squirrel@pezone.net> <44B7ADFC.90205@dunslane.net> <44BC0432.3040509@joeconway.com> <44BC661F.80609@joeconway.com> <44BCD06C.3060409@calorieking.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.19 (linux) Cancel-Lock: sha1:hYW48upbeG2Rnx4zagUIL3b3v5g= To: pgsql-patches@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/140 X-Sequence-Number: 20294 chris.kings-lynne@calorieking.com (Christopher Kings-Lynne) writes: >> 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. Curiosity: How do *does* TheirSQL parse that, and not have the One Gigantic Query blow up their query parser? -- output = reverse("gro.gultn" "@" "enworbbc") http://www.ntlug.org/~cbbrowne/unix.html JOHN CAGE (strapped to table): Do you really expect me to conduct this antiquated tonal system? LEONARD BERNSTEIN: No, Mr. Cage, I expect you to die! [With apologies to music and James Bond fans the world over...]