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 7EEC05E4733 for ; Thu, 2 Sep 2004 11:48:43 -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 09416-02 for ; Thu, 2 Sep 2004 14:48:40 +0000 (GMT) Received: from emo.org.tr (emo.org.tr [195.142.105.9]) by svr1.postgresql.org (Postfix) with ESMTP id 771C55E472F for ; Thu, 2 Sep 2004 11:48:37 -0300 (ADT) Received: by emo.org.tr (Postfix, from userid 41643) id 44E8D2FDA0; Thu, 2 Sep 2004 17:48:38 +0300 (EEST) Received: from localhost (localhost [127.0.0.1]) by emo.org.tr (Postfix) with ESMTP id 3CBBD111ED7; Thu, 2 Sep 2004 17:48:38 +0300 (EEST) Date: Thu, 2 Sep 2004 17:48:35 +0300 (EEST) From: Devrim GUNDUZ X-X-Sender: devrim2@emo.org.tr To: Nosyman Cc: pgsql-sql@postgresql.org Subject: Re: PRIMARY KEY and INDEX In-Reply-To: <200409021358.i82DwGQ8022806@acten.itcnet.ro> Message-ID: References: <200409021358.i82DwGQ8022806@acten.itcnet.ro> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=UPPERCASE_25_50 X-Spam-Level: X-Archive-Number: 200409/28 X-Sequence-Number: 18874 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, On Thu, 2 Sep 2004, Nosyman wrote: > 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? You could give it a try before asking: test=# CREATE TABLE users( test(# id_user INTEGER PRIMARY KEY, test(# user_name VARCHAR(25) test(# ); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "users_pkey" for table "users" CREATE TABLE Regards, - -- Devrim GUNDUZ devrim~gunduz.org devrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFBNzLFtl86P3SPfQ4RAuOZAKDoE5NFtu7B3Dg356+CH5P9CGp7cgCfaBQm 33nie6C/x2PIfA0D1zqWgLE= =QlUA -----END PGP SIGNATURE-----