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

Re: Adding Serial Type

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: David Pratt <fairwinds(at)eastlink(dot)ca>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Adding Serial Type
Date: 2005-05-28 18:27:54
Message-ID: 20050528182754.GA11909@wolff.to (view raw or flat)
Thread:
Lists: pgsql-admin
On Sat, May 28, 2005 at 14:27:17 -0300,
  David Pratt <fairwinds(at)eastlink(dot)ca> wrote:
> Pretty basic question. Is it necessary to add NOT NULL or UNIQUE NOT 
> NULL to SERIAL or is this implicit and unnecessary?

Serials no longer generate a uniqie index by default. So in practice
you will normally want to declare them as PRIMARY KEYs. However there
are cases where you don't need this and the index is extra overhead.

In response to

Responses

pgsql-admin by date

Next:From: David PrattDate: 2005-05-28 19:18:30
Subject: Re: Adding Serial Type
Previous:From: David PrattDate: 2005-05-28 17:27:17
Subject: Adding Serial Type

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