Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 320142E00E9
	for <pgsql-docs-postgresql.org@postgresql.org>;
	Wed,  5 Mar 2008 12:54:14 -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 66366-06 for <pgsql-docs-postgresql.org@postgresql.org>;
	Wed,  5 Mar 2008 12:54:04 -0400 (AST)
X-Greylist: delayed 00:20:52.808378 by SQLgrey-1.7.5
Received: from macprofessionals.com (66.238.128.226.ptr.us.xo.net
	[66.238.128.226])
	by postgresql.org (Postfix) with ESMTP id F28392E01CB
	for <pgsql-docs@postgresql.org>; Wed,  5 Mar 2008 12:54:04 -0400 (AST)
Received: from localhost (localhost [127.0.0.1])
	by macprofessionals.com (Postfix) with ESMTP id 841121F4611B
	for <pgsql-docs@postgresql.org>; Wed,  5 Mar 2008 11:33:10 -0500 (EST)
Received: from macprofessionals.com ([127.0.0.1])
	by localhost (webserv.macprofessionals.com [127.0.0.1]) (amavisd-new,
	port 10024) with ESMTP id 07893-04 for <pgsql-docs@postgresql.org>;
	Wed,  5 Mar 2008 11:32:57 -0500 (EST)
Received: from [172.20.20.64] (unknown [172.20.20.64])
	by macprofessionals.com (Postfix) with ESMTP id C85711F460B8
	for <pgsql-docs@postgresql.org>; Wed,  5 Mar 2008 11:32:57 -0500 (EST)
Mime-Version: 1.0 (Apple Message framework v753)
In-Reply-To: <200803051620.m25GKW328140@momjian.us>
References: <200803051620.m25GKW328140@momjian.us>
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Message-Id: <4820142F-4F52-4EA4-AA64-7A110AA852DF@macprofessionals.com>
Content-Transfer-Encoding: 7bit
From: Phil Frost <phil@macprofessionals.com>
Subject: Re: Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column
	values
Date: Wed, 5 Mar 2008 11:32:57 -0500
To: PostgreSQL-documentation <pgsql-docs@postgresql.org>
X-Mailer: Apple Mail (2.753)
X-Virus-Scanned: by amavisd-new at macprofessionals.com
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.048 tagged_above=0 required=5 tests=AWL=-0.052,
	RDNS_DYNAMIC=0.1
X-Spam-Level: 
X-Archive-Number: 200803/10
X-Sequence-Number: 4822

On Mar 5, 2008, at 11:20 , Bruce Momjian wrote:

>
> Does anyone think it is a good idea to document that our indexes  
> cannot
> index arbirarily-long strings?  I see nothing in the documentation now
> about it.

+1

I never even knew. I'd be especially interested to hear about  
details, like how long strings can be until they are not guaranteed  
unique.