Re: Why doesn't the SERIAL data type automatically have a UNIQUE CONSTRAINT

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: fmiddleton(at)verizon(dot)net
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Why doesn't the SERIAL data type automatically have a UNIQUE CONSTRAINT
Date: 2005-09-27 01:03:18
Message-ID: 5899.1127782998@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Ferindo Middleton Jr <fmiddleton(at)verizon(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ferindo Middleton Jr 2005-09-27 02:53:25 Re: Why doesn't the SERIAL data type automatically have a UNIQUE
Previous Message Anthony Molinaro 2005-09-27 00:58:40 Re: how to do 'deep queries'?