Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Why doesn't the SERIAL data type automatically have a UNIQUE CONSTRAINT
Date
Msg-id 5899.1127782998@sss.pgh.pa.us
Whole thread Raw
In response to Why doesn't the SERIAL data type automatically have a UNIQUE CONSTRAINT  (Ferindo Middleton Jr <fmiddleton@verizon.net>)
Responses Re: Why doesn't the SERIAL data type automatically have a UNIQUE
Re: Why doesn't the SERIAL data type automatically have a
Re: Why doesn't the SERIAL data type automatically have a
List pgsql-sql
Tree view 
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 ...
        regards, tom lane

pgsql-sql by date:

Previous
From: "Anthony Molinaro"
Date:
Subject: Re: how to do 'deep queries'?
Next
From: Ferindo Middleton Jr
Date:
Subject: Re: Why doesn't the SERIAL data type automatically have a UNIQUE