Skip site navigation (1) Skip section navigation (2)

Re: Setting primary key on existing table

From: Doug Silver <dsilver(at)urchin(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Setting primary key on existing table
Date: 2002-09-25 17:38:24
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Hi Tom -

Anyway to do this on an existing table or do I have to recreate it?


On Wednesday 25 September 2002 10:20 am, you wrote:
> Doug Silver <dsilver(at)urchin(dot)com> writes:
> > I would like to be able to redefine a field in a table to be a foreign
> > reference -- however this field was initially defined as just "serial"
> > and not "serial primary key".  I tried to add that constraint to the
> > table, but it didn't work.
> AFAIR, "serial" implies "unique not null" (at least in pre-7.3
> releases), so your column is a primary key in all but name.  All you'd
> get from marking it as primary key is not having to mention the column
> name when defining the foreign key reference.  Is it good enough to
> just write
> 		... foo int REFERENCES mytable(mycol)
> ?
> 			regards, tom lane
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

Doug Silver
Network Manager
Urchin Software Corp.

In response to

pgsql-novice by date

Next:From: denisDate: 2002-09-26 05:20:50
Subject: Vacuum again and again
Previous:From: Tom LaneDate: 2002-09-25 17:21:20
Subject: Re: Setting primary key on existing table

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group