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
- analyze.c.patch (text/plain) patch
> > 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