Re: Why doesn't the SERIAL data type automatically have a - Mailing list pgsql-sql

From Scott Marlowe
Subject Re: Why doesn't the SERIAL data type automatically have a
Date
Msg-id 1127835194.29347.12.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: Why doesn't the SERIAL data type automatically have a UNIQUE CONSTRAINT  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
On Mon, 2005-09-26 at 20:03, Tom Lane wrote:
> Ferindo Middleton Jr <fmiddleton@verizon.net> writes:
> > Is there some reason why the SERIAL data type doesn't automatically have 
> > a UNIQUE CONSTRAINT.
> 
> It used to, and then we decoupled it.  I don't think "I have no use for
> one without the other" translates to an argument that no one has a use
> for it ...

I have to admit, right after the change was made, I was of the opinion
that no one would ever need that.  Then, a few months later, it was
exactly what I needed for some project...  :)


pgsql-sql by date:

Previous
From: Axel Rau
Date:
Subject: Re: Updating cidr column with network operator
Next
From: Daryl Richter
Date:
Subject: Re: how to do 'deep queries'?