Re: [HACKERS] Re: Serial Data Type Failure

Thomas Lockhart <lockhart@alumni.caltech.edu>

From: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
To: David Hartwig <daveh@insightdist.com>, pgsql-hackers <pgsql-hackers@postgreSQL.org>
Date: 1998-09-21T05:41:25Z
Lists: pgsql-hackers

Attachments

> > ERROR:  Cannot create index: 'bar_id_key' already exists
> > -- This is bad.  Sorry.

postgres=> CREATE TABLE bar (
postgres->         id serial,
postgres->         name varchar(32)
postgres-> );
NOTICE:  CREATE TABLE will create implicit sequence bar_id_seq for
SERIAL column bar.id
NOTICE:  CREATE TABLE/UNIQUE will create implicit index bar_id_key for
table bar
CREATE

I hadn't noticed that there was a positional dependency in the code I
had moved around to implement the SERIAL PRIMARY KEY feature. Sorry
about that.

Patch enclosed. Will commit to source tree soon...

                   - Tom