Received: from email.opla.it ([217.57.174.188]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBJCvdm35257 for ; Wed, 19 Dec 2001 07:57:51 -0500 (EST) (envelope-from giorgio@opla.it) Received: from oplantserver (firewall [217.57.174.189]) by email.opla.it (8.11.2/8.11.2) with SMTP id fBJDrDB09102 for ; Wed, 19 Dec 2001 14:53:13 +0100 Message-ID: <002601c1888d$9ac2aba0$c801a8c0@opla.it> From: "Giorgio Ponza" To: References: Subject: Stupid question on INDEXES Date: Wed, 19 Dec 2001 14:03:50 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200112/91 X-Sequence-Number: 2634 I'd like to know if i think in the right way. With CREATE TABLE Test1 ( my_id int, descr text, primary key (my_id)) Postgres automatically creates an index named test1_pkey. If i use CREATE TABLE Test1 ( my_id int, descr text) without specifying a pkey, i can write create unique index i_test1_pkey on (my_id). The only difference is that in the 2nd case i can use the name i want, or the usage is different? Many thanks Giorgio