Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 5E26E1337B5E for ; Thu, 13 Jan 2011 07:24:28 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 84947-09 for ; Thu, 13 Jan 2011 11:24:20 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from acidenitrix.villemain.org (acidenitrix.villemain.org [91.121.90.165]) by mail.postgresql.org (Postfix) with ESMTP id 3702B1337B43 for ; Thu, 13 Jan 2011 07:24:20 -0400 (AST) Received: from localhost ([127.0.0.1] helo=dim) by acidenitrix.villemain.org with esmtpsa (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.69) (envelope-from ) id 1PdLHv-0008Vx-Fp; Thu, 13 Jan 2011 12:24:19 +0100 Received: by dim (Postfix, from userid 1000) id A7E70754F4; Thu, 13 Jan 2011 12:24:18 +0100 (CET) From: Dimitri Fontaine To: Tom Lane Cc: "David E. Wheeler" , pgsql-hackers@postgresql.org Subject: Re: Fixing GIN for empty/null/full-scan cases Organization: 2ndQuadrant References: <15190.1294175357@sss.pgh.pa.us> <15816.1294177767@sss.pgh.pa.us> <4D23AAD6.8020700@agliodbs.com> <9D548B31-7C3B-4D92-B591-80A1FBE5B657@kineticode.com> <4049.1294445970@sss.pgh.pa.us> <13EE8904-90AA-438B-8792-B00743ED9B0D@kineticode.com> <29662.1294551673@sss.pgh.pa.us> <85DBCDB8-CD8A-47DD-B41A-C50742F52DB4@kineticode.com> <29367.1294878920@sss.pgh.pa.us> <5DB905A3-EADB-467B-BAFB-3CFB7B4A8019@kineticode.com> <2354.1294881123@sss.pgh.pa.us> User-Mail-Address: dimitri@2ndQuadrant.fr Date: Thu, 13 Jan 2011 12:24:18 +0100 In-Reply-To: <2354.1294881123@sss.pgh.pa.us> (Tom Lane's message of "Wed, 12 Jan 2011 20:12:03 -0500") Message-ID: <87fwsxxd0d.fsf@hi-media-techno.com> User-Agent: Gnus/5.110011 (No Gnus v0.11) Emacs/23.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201101/955 X-Sequence-Number: 178792 Tom Lane writes: > "David E. Wheeler" writes: >> On Jan 12, 2011, at 4:35 PM, Tom Lane wrote: >>> No, what we need is a decent extension package manager ;-) > >> Yeah. Maybe you can do that this weekend? Or, I dunno, while you =C2=93s= leep=C2=94 tonight? > > Supposedly it's in the queue for the upcoming CF :-) Hehe, and some provision have been made to support upgrading from 9.0 to 9.1 too: http://pgsql.tapoueh.org/extensions/doc/html/extend-extension.html#AEN507= 48 But that won't solve the dump-from-9.0 and restore-into-9.1 by itself, the only way for us to solve that problem that I can think of would be to backpatch a new feature. Do it the old-way until you upgrade from 9.1 to later might be our answer here. Regards, --=20 Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support