Postgres Pro
Downloads
Home   >   mailing lists

Re: duplicate key violates unique constraint - Mailing list pgsql-admin

From Jim Nasby
Subject Re: duplicate key violates unique constraint
Date
Msg-id 7D0DBA1F-6A76-4BEE-B2D5-193180F7B8C3@decibel.org
Whole thread Raw
In response to Re: duplicate key violates unique constraint  (Carol Walter <walterc@indiana.edu>)
Responses Re: duplicate key violates unique constraint  (Carol Walter <walterc@indiana.edu>)
List pgsql-admin
Tree view 
On May 10, 2007, at 9:01 AM, Carol Walter wrote:
> And this is more than a question than an answer, but I thought that
> sequences had to designated as data type "serial."

Nope... sequences are actually completely un-related to tables. You
can define a sequence that's not referenced by any table. The serial
data type is essentially a 'macro' that:

Creates a sequence
Sets the default value for the field to be the nextval() of that
sequence
Sets the field to be NOT NULL
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

pgsql-admin by date:

Previous
From: Steve Holdoway
Date:
Subject: Re: upgrade 8.0.3 -> 8.2.4
Next
From: Carol Walter
Date:
Subject: Re: duplicate key violates unique constraint