Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C79982E02B4 for ; Wed, 5 Mar 2008 12:56: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 67095-05-2 for ; Wed, 5 Mar 2008 12:56:45 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from momjian.us (momjian.us [70.90.9.53]) by postgresql.org (Postfix) with ESMTP id D21522E0386 for ; Wed, 5 Mar 2008 12:56:45 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id m25GuiO17779; Wed, 5 Mar 2008 11:56:44 -0500 (EST) From: Bruce Momjian Message-Id: <200803051656.m25GuiO17779@momjian.us> Subject: Re: Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values In-Reply-To: <4820142F-4F52-4EA4-AA64-7A110AA852DF@macprofessionals.com> To: Phil Frost Date: Wed, 5 Mar 2008 11:56:44 -0500 (EST) CC: PostgreSQL-documentation X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/11 X-Sequence-Number: 4823 Phil Frost wrote: > 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. Part of the problem is we don't know the length --- it is the compressed length that is limited, I think to 8k. -- Bruce Momjian http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +