| 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 02:13:03 |
| Message-ID: | MABBJIIJCNOHJDEFAAJEEEKOCEAA.mikhail.malamud@drexel.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Can someone please tell me the answer to this simple question?
-----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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Olbersen | 2001-03-13 02:13:04 | Re: Number of Records in a Table |
| Previous Message | Tom Lane | 2001-03-12 23:45:52 | Re: counting rows of grouped query (problem with views) |