Received: from wilson.acpub.duke.edu (wilson.acpub.duke.edu [152.3.233.69]) by postgresql.org (Postfix) with ESMTP id 529DA4759A9 for ; Thu, 7 Mar 2002 16:53:32 -0500 (EST) Received: from [152.3.11.193] (bglab2.botany.duke.edu [152.3.11.193]) by wilson.acpub.duke.edu (8.11.5/8.11.3/Duke-5.0.0) with ESMTP id g27LrWX12296; Thu, 7 Mar 2002 16:53:32 -0500 (EST) Mime-Version: 1.0 X-Sender: chauser@mail-ch.acpub.duke.edu Message-Id: Date: Thu, 7 Mar 2002 16:53:35 -0500 To: pgsql-sql@postgresql.org From: Charles Hauser Subject: ALTER CONSTRAINT FOREIGN KEY Content-Type: text/plain; charset="us-ascii" ; format="flowed" X-Virus-Scanned: by amavisd-milter, Duke University (http://amavis.org/) X-Archive-Number: 200203/143 X-Sequence-Number: 7023 Question, When I created a TABLE clone I initially defined a column: gb_accessions_id INTEGER REFERENCES gb_accessions(gb_accessions_id) NULL I have renamed TABLE gb_accessions to TABLE gb, and its column gb_accessions_id to gb_id. I next renamed the column 'gb_accessions_id' in TABLE clone to 'gb_id'. In renaming this column in TABLE clone I appear to have lost the reference to TABLE gb (see below). Questions: 1. During which step in my renaming did this occur? 2. How should I have carried this out? 3. Can I add back REFERENCES gb(gb_id)? Database chlamy_est - Table clone Field Type LengthNot Null Default clone_id int4 4 Yes nextval('"clone_clone_id_seq"'::text) project int4 4 Yes plate int4 4 Yes row char 1 Yes col int4 4 Yes read char 1 Yes ver int4 4 Yes seq text var Yes qual text var Yes length int4 4 Yes qual_length int4 4 Yes mean_qual_after_trim int4 4 Yes qual_start int4 4 Yes qual_end int4 4 Yes comment text var Yes gb_id int4 4 No Keyname Unique Primary Field clone_pkey Yes Yes clone_id clone_project_key Yes No col clone_project_key Yes No plate clone_project_key Yes No project clone_project_key Yes No read clone_project_key Yes No row clone_project_key Yes No ver Thanks. -- Regards, Chuck