Received: from snfc21.pbi.net (mta6.snfc21.pbi.net [206.13.28.240]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7L6hrP26712 for ; Tue, 21 Aug 2001 02:43:53 -0400 (EDT) (envelope-from GonzoRock@Excite.com) Received: from charlie2 ([66.121.57.207]) by mta6.snfc21.pbi.net (iPlanet Messaging Server 5.1 (built May 7 2001)) with SMTP id <0GIE00DMHO0YU8@mta6.snfc21.pbi.net> for pgsql-sql@postgresql.org; Mon, 20 Aug 2001 23:43:47 -0700 (PDT) Date: Mon, 20 Aug 2001 23:45:10 -0700 From: Gonzo Rock Subject: Primary vs Unique Index X-Sender: sbames@postoffice.pacbell.net (Unverified) To: pgsql-sql@postgresql.org Message-id: <3.0.5.32.20010820234510.009c5530@postoffice.pacbell.net> MIME-version: 1.0 X-Mailer: QUALCOMM Windows Eudora Pro Version 3.0.5 (32) Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7BIT X-Archive-Number: 200108/260 X-Sequence-Number: 4507 Why would one need a Primary Key... which can only be declared at table creation if one can create a Unique Index post table creation? ie: I deleted my primary key... is that a big deal? What's the purpose of the Primary Key if it's function can be duplicated with another Unique Index? thanks,