X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 42A6ED1B461 for ; Wed, 10 Mar 2004 17:17:40 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 71573-02 for ; Wed, 10 Mar 2004 13:17:34 -0400 (AST) Received: from greendale.ukc.ac.uk (greendale.ukc.ac.uk [129.12.21.13]) by svr1.postgresql.org (Postfix) with ESMTP id E0FAED1C513 for ; Wed, 10 Mar 2004 13:17:33 -0400 (AST) Received: from pelican.ukc.ac.uk ([129.12.200.26]) by greendale.ukc.ac.uk with esmtp (Exim 4.22) id 1B17KJ-0000ly-LI for pgsql-sql@postgresql.org; Wed, 10 Mar 2004 17:17:03 +0000 Received: from dhcp6642.ukc.ac.uk ([129.12.102.66] helo=PC2LP051) by pelican.ukc.ac.uk with smtp (Exim 4.22) id 1B17KH-00030M-Jq for pgsql-sql@postgresql.org; Wed, 10 Mar 2004 17:17:01 +0000 Message-ID: <007101c406c3$807a13d0$42660c81@ad.kent.ac.uk> From: "David" To: Subject: Changing primary keys Date: Wed, 10 Mar 2004 17:17:01 -0000 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.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-UKC-Mail-System: No virus detected X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/109 X-Sequence-Number: 17208 Is it possible to change the primary key of a relation? I want to add an attribute, that i already have in the realtion, to the primary key (yes i realise i designed my model pretty badly)