Re: [HACKERS] Re: Serial Data Type Failure

> > 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
*** analyze.c.orig    Wed Sep 16 14:59:22 1998
--- analyze.c    Mon Sep 21 05:18:07 1998
***************
*** 517,528 ****

                  if (column->is_sequence)
                  {
!                     char       *cstring;
                      CreateSeqStmt *sequence;

                      constraint = makeNode(Constraint);
                      constraint->contype = CONSTR_DEFAULT;
!                     constraint->name = makeTableName(stmt->relname, column->colname, "seq", NULL);
                      cstring = palloc(9 + strlen(constraint->name) + 2 + 1);
                      strcpy(cstring, "nextval('");
                      strcat(cstring, constraint->name);
--- 517,529 ----

                  if (column->is_sequence)
                  {
!                     char          *sname;
!                     char          *cstring;
                      CreateSeqStmt *sequence;

                      constraint = makeNode(Constraint);
                      constraint->contype = CONSTR_DEFAULT;
!                     constraint->name = sname = makeTableName(stmt->relname, column->colname, "seq", NULL);
                      cstring = palloc(9 + strlen(constraint->name) + 2 + 1);
                      strcpy(cstring, "nextval('");
                      strcat(cstring, constraint->name);
***************
*** 551,557 ****
                      }

                      sequence = makeNode(CreateSeqStmt);
!                     sequence->seqname = pstrdup(constraint->name);
                      sequence->options = NIL;

                      elog(NOTICE, "CREATE TABLE will create implicit sequence %s for SERIAL column %s.%s",
--- 552,558 ----
                      }

                      sequence = makeNode(CreateSeqStmt);
!                     sequence->seqname = pstrdup(sname);
                      sequence->options = NIL;

                      elog(NOTICE, "CREATE TABLE will create implicit sequence %s for SERIAL column %s.%s",