X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 5A798D1C932; Tue, 5 Aug 2003 14:02:27 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 11546-02; Tue, 5 Aug 2003 11:01:12 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 420B9D1C9C9; Tue, 5 Aug 2003 11:02:16 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h75E2KSa021986; Tue, 5 Aug 2003 10:02:20 -0400 (EDT) To: The Hermit Hacker Cc: pgsql-docs@postgresql.org Subject: Re: duplicated index entry found ... In-reply-to: <20030805012911.D1434@hub.org> References: <20030805012911.D1434@hub.org> Comments: In-reply-to The Hermit Hacker message dated "Tue, 05 Aug 2003 01:29:42 -0300" Date: Tue, 05 Aug 2003 10:02:20 -0400 Message-ID: <21985.1060092140@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/35 X-Sequence-Number: 1895 The Hermit Hacker writes: > duplicated index entry found, CHARACTER STRINGS LENGTH > duplicated index entry found, LENGTH CHARACTER STRINGS > duplicated index entry found, SUBSTRING > duplicated index entry found, SUBSTRING > 4 entries ignored... Yeah, I've been seeing that for quite some time, but haven't been able to figure out what it's complaining about. Surely multiple index entries for the same term are legal, so what's its beef? regards, tom lane