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>
Cc: pgsql-hackers <pgsql-hackers@postgreSQL.org>
Date: 1998-09-21T00:50:13Z
Lists: pgsql-hackers
> The following came from the most recient snapshot.
> CREATE TABLE bar (
> id serial,
> name varchar(32)
> );
> NOTICE: CREATE TABLE will create implicit sequence bar_id_key for
> SERIAL column bar.id
> NOTICE: CREATE TABLE/UNIQUE will create implicit index bar_id_key for
> table bar
> ERROR: Cannot create index: 'bar_id_key' already exists
> -- This is bad. Sorry.
OK, will look at it if you haven't fixed it already...
- Tom