| From: | "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu> |
|---|---|
| To: | "P(dot) Dwayne Miller" <dmiller(at)espgroup(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Adding a primary key |
| Date: | 2001-06-12 20:57:35 |
| Message-ID: | Pine.LNX.4.21.0106121656510.19889-100000@aluminum.cs.pitt.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
You can only define the pri key on table creation. If you miss it there, you can only add a Unique index (which is pretty much the same I think)
Check http://www.postgresql.org/idocs/index.php?sql-altertable.html
cheers,
thalis
On Tue, 12 Jun 2001, P. Dwayne Miller wrote:
> How do I add a primary key to a table. The database was migrated using
> pgAdmin and no indexes or keys were migrated. I'd like to add a primary
> key constraint to a table.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Zach | 2001-06-12 20:57:56 | Re: rtree index very large |
| Previous Message | Thalis A. Kalfigopoulos | 2001-06-12 20:55:56 | Re: Please help! Functions passing records between them |