Hi Folks, I'm trying to use the ALTER TABLE command to add a primary key to a table.
The command I am using is: ALTER TABLE "agency_contact_info" ADD CONSTRAINT "agency_contact_info_pkey" PRIMARY KEY ("id"); I get a message saying "ALTER TABLE / ADD CONSTRAINT not implemented for that constraint type". Is this a bug, or am I doing something wrong? The reason I am trying to do this is that I want to split a table with a large number of fields up into a few tables with a sub-set of fields from the original table, linked by FOREIGN KEY on "id". I had thought the best way to do this was to use SELECT INTO and then try to alter the tables to include PRIMARY and FOREIGN keys where applicable. Is there a better way to do this? Thanks, Tom _______________________________ Tom Haddon IT Director The Better Health Foundation 414 Thirteenth Street, Suite 450 Oakland, CA 94612 (510) 444-5096 www.betterhealthfoundation.org _______________________________ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly