Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id C56472E007D
	for <pgsql-docs-postgresql.org@postgresql.org>;
	Wed,  5 Mar 2008 13:09:57 -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 72508-02 for <pgsql-docs-postgresql.org@postgresql.org>;
	Wed,  5 Mar 2008 13:09:46 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by postgresql.org (Postfix) with ESMTP id 142A82E2EB9
	for <pgsql-docs@postgresql.org>; Wed,  5 Mar 2008 13:09:46 -0400 (AST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m25H9icE000360;
	Wed, 5 Mar 2008 12:09:44 -0500 (EST)
To: Bruce Momjian <bruce@momjian.us>
cc: Phil Frost <phil@macprofessionals.com>,
	PostgreSQL-documentation <pgsql-docs@postgresql.org>
Subject: Re: Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column
	values
In-reply-to: <200803051656.m25GuiO17779@momjian.us> 
References: <200803051656.m25GuiO17779@momjian.us>
Comments: In-reply-to Bruce Momjian <bruce@momjian.us>
	message dated "Wed, 05 Mar 2008 11:56:44 -0500"
Date: Wed, 05 Mar 2008 12:09:44 -0500
Message-ID: <359.1204736984@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200803/12
X-Sequence-Number: 4824

Bruce Momjian <bruce@momjian.us> writes:
> Part of the problem is we don't know the length --- it is the compressed
> 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?

			regards, tom lane