X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C40E65E472F for ; Thu, 2 Sep 2004 11:29:57 -0300 (ADT) 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 83908-04 for ; Thu, 2 Sep 2004 14:29:54 +0000 (GMT) Received: from acten.itcnet.ro (unknown [193.231.172.14]) by svr1.postgresql.org (Postfix) with ESMTP id 7071A5E46F8 for ; Thu, 2 Sep 2004 11:29:51 -0300 (ADT) Received: from acten.itcnet.ro (localhost.localdomain [127.0.0.1]) by acten.itcnet.ro (8.12.6-20030917/8.12.6) with ESMTP id i82DwG9B022807 for ; Thu, 2 Sep 2004 16:58:16 +0300 Received: (from apache@localhost) by acten.itcnet.ro (8.12.6-20030917/8.12.6/Submit) id i82DwGQ8022806; Thu, 2 Sep 2004 16:58:16 +0300 Message-Id: <200409021358.i82DwGQ8022806@acten.itcnet.ro> Received: from client 81.196.16.98 for UebiMiau2.7 (webmail client); Thu, 2 Sep 2004 16:58:16 -0000 Date: Thu, 2 Sep 2004 16:58:16 -0000 From: "Nosyman" To: pgsql-sql@postgresql.org Reply-To: "Nosyman" Subject: PRIMARY KEY and INDEX X-Priority: 3 X-Mailer: X-Original-IP: 81.196.16.98 Content-Transfer-Encoding: 8bit X-MSMail-Priority: Medium Importance: Medium Content-Type: text/plain; charset="iso-8859-1"; MIME-Version: 1.0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.7 tagged_above=0.0 required=5.0 tests=MISSING_MIMEOLE, MSGID_FROM_MTA_HEADER, PRIORITY_NO_NAME X-Spam-Level: ** X-Archive-Number: 200409/26 X-Sequence-Number: 18872 It is necessary to define an index for a primary key column? Let's have an example CREATE TABLE users( id_user INTEGER PRIMARY KEY, user_name VARCHAR(25) ); Does PgSQL automatically create an index for id_user (primary key) or it must be created by hand? Thanks _________________________________________________________________ Message sent using ITCNet free webmailer (http://www.easymail.ro)