X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 140AB3A412D for ; Tue, 23 Nov 2004 22:41:29 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 20513-03 for ; Tue, 23 Nov 2004 22:41:12 +0000 (GMT) Received: from hotmail.com (bay101-f33.bay101.hotmail.com [64.4.56.43]) by svr1.postgresql.org (Postfix) with ESMTP id 371143A4120 for ; Tue, 23 Nov 2004 22:41:09 +0000 (GMT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 23 Nov 2004 14:41:03 -0800 Message-ID: Received: from 65.242.105.130 by by101fd.bay101.hotmail.msn.com with HTTP; Tue, 23 Nov 2004 22:40:22 GMT X-Originating-IP: [65.242.105.130] X-Originating-Email: [dedeb17@hotmail.com] X-Sender: dedeb17@hotmail.com From: "Sally Sally" To: pgsql-admin@postgresql.org Subject: primary key and the default index operator class Date: Tue, 23 Nov 2004 22:40:22 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 23 Nov 2004 22:41:03.0914 (UTC) FILETIME=[8382A0A0:01C4D1AD] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.6 tagged_above=0.0 required=5.0 tests=FROM_ENDS_IN_NUMS, MSGID_FROM_MTA_HEADER X-Spam-Level: * X-Archive-Number: 200411/175 X-Sequence-Number: 15559 I am trying to figure out how I can change the default operator class of the index created for my primary key field. Is it even possible since I am not able to find the syntax? Or do I need to create the primary key and then an additional index with the operator class I want. (It would be a waste of space) Thanks Sally