"Alan T. Miller" <amiller(at)hollywood101(dot)com> writes:
> If I create a table and assign the column type for what will be the primary
> key the value of "Serial", do I need to explicitly create an index in
Either PRIMARY KEY or UNIQUE implies an index (for any column datatype).
They even put out notices to tell you so.
> I was thinking that a Serial, would automatically be a Unique Index wouldn't
Not in recent releases --- a SERIAL column is just an integer with a
special default value.
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: G. Walsh||Date: 2004-01-03 18:25:13|
|Subject: More on creating data bases for 4 distinct users|
|Previous:||From: Andreas||Date: 2004-01-03 15:26:15|
|Subject: Re: Question about Indexes...|