From: | "mikhail malamud" <mikhail(dot)malamud(at)drexel(dot)edu> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | RE: add primary key |
Date: | 2001-03-13 16:41:28 |
Message-ID: | MABBJIIJCNOHJDEFAAJEKEMDCEAA.mikhail.malamud@drexel.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I ve been trying to find an answer to this question but all in vain. Can
someone pleease help me. How do you add a primary key constraint to an
existing table.
-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of mikhail malamud
Sent: Saturday, March 10, 2001 10:55 PM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] add primary key
ALTER TABLE Activity add
CONSTRAINT PRIMARY KEY
(
ActivityId
)
What's wrong with this. How do I add primary key constraint.
I tried to look in the docs but I could not find the answer, can anyone
also point me to a place where I could find an answer to this question
without disturbing the entire mailing list with such a probably simple
question.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | Brett W. McCoy | 2001-03-13 16:59:18 | Re: perl installation problem and installation of postgres from rpms |
Previous Message | Ken Corey | 2001-03-13 15:55:48 | Re: Fwd: Silly question about numbering of rows? |