Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 851122E1083 for ; Wed, 5 Mar 2008 14:30:39 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 90165-09 for ; Wed, 5 Mar 2008 14:30:34 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from rn-out-0910.google.com (rn-out-0910.google.com [64.233.170.188]) by postgresql.org (Postfix) with ESMTP id 1DC232E00CF for ; Wed, 5 Mar 2008 14:30:35 -0400 (AST) Received: by rn-out-0910.google.com with SMTP id e5so426884rng.0 for ; Wed, 05 Mar 2008 10:30:34 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=m3ovMpMncTpACMC5iB6Y0ZHy9cVC0dFqSXi+0vnGsCM=; b=cyfwOgkvI8GX+bYxJx0rTTNbM1RUzCS63ahn/hFZNju94sctMfkEWE7yrqYsbtSHODLPV9Sp7WDUMg9ToipDAtd0yQwlV9B6d5XCCHGa2pViei6EP7PM+kBM9LPeGVSjJMETKOsRDcJlK7HijP/LRG4MdJmMXg7f8Oux9GJqxZA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=eJgaerU1CTrHOlYBE0xnJG72CBJUKPoSQ0Rfl1Ndbc5ArA0uwlFQXw5x8+RVWuSoVIPgAE3pxJJpGjTyLxDp+8jQsfb9SngJ+ul/hxGB/Ou6WHG1aDmplQBGH8ZY9rUKJTJVmiirIX3XSHJKSIl81LKCtLqOpNToiD9GABSImJ0= Received: by 10.114.201.1 with SMTP id y1mr4992715waf.121.1204741833168; Wed, 05 Mar 2008 10:30:33 -0800 (PST) Received: by 10.114.102.7 with HTTP; Wed, 5 Mar 2008 10:30:33 -0800 (PST) Message-ID: <65937bea0803051030q6b8800c0pb6db4e7cae0bb45e@mail.gmail.com> Date: Thu, 6 Mar 2008 00:00:33 +0530 From: "Gurjeet Singh" To: "Tom Lane" Subject: Re: Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values Cc: "Bruce Momjian" , "Phil Frost" , PostgreSQL-documentation In-Reply-To: <359.1204736984@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3939_17354978.1204741833112" References: <200803051656.m25GuiO17779@momjian.us> <359.1204736984@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/18 X-Sequence-Number: 4830 ------=_Part_3939_17354978.1204741833112 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On Wed, Mar 5, 2008 at 10:39 PM, Tom Lane wrote: > Bruce Momjian writes: > > Part of the problem is we don't know the length --- it is the compresse= d > > length that is limited, I think to 8k. > > That's a problem, and the length limit is different for different index > types. So you're really not going to be able to say anything very > specific. Another problem is where would you put the information? In 'CREATE INDEX' docs... http://www.postgresql.org/docs/8.3/interactive/sql-createindex.html Along with the following statement: method: The name of the index method to be used. Choices are btree, hash, gist, and gin. The default method is btree. Best regards, --=20 gurjeet[.singh]@EnterpriseDB.com singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com EnterpriseDB http://www.enterprisedb.com 17=B0 29' 34.37"N, 78=B0 30' 59.76"E - Hyderabad * 18=B0 32' 57.25"N, 73=B0 56' 25.42"E - Pune 37=B0 47' 19.72"N, 122=B0 24' 1.69" W - San Francisco http://gurjeet.frihost.net Mail sent from my BlackLaptop device ------=_Part_3939_17354978.1204741833112 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On Wed, Mar 5, 2008 at 10:39 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Bruce Momjian <bruce@momjian.us> writes:
> Part of the problem is we don't know the length --- it is the comp= ressed
> length that is limited, I think to 8k.

That's a problem, and the length limit is different for different= index
types.  So you're really not going to be able to say anything very=
specific.  Another problem is where would you put the information?

Along with the following statement:

method: The name= of the index method to be used. Choices are btree, hash, gist, and gin. The default method is btree.

Best regards,
--
gurjeet[.singh]@= EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.= com

EnterpriseDB      http://www.enterprisedb.com

17=B0 29' 34.37"N,  78=B0 30' 59.76"E - Hyderaba= d *
18=B0 32' 57.25"N,  73=B0 56' 25.42"E - Pune<= br>37=B0 47' 19.72"N, 122=B0 24' 1.69" W - San Francisco<= br>
http://gurjeet.frihost.net

Mail sent from my BlackLaptop device ------=_Part_3939_17354978.1204741833112--