Re: [HACKERS] Re: Serial Data Type Failure

From: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
To: David Hartwig <daveh(at)insightdist(dot)com>, pgsql-hackers <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [HACKERS] Re: Serial Data Type Failure
Date: 1998-09-21 05:41:25
Message-ID: 3605E705.3E9A0ADA@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > 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

Attachment Content-Type Size
analyze.c.patch text/plain 1.5 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 1998-09-21 05:55:30 Re: My patches
Previous Message Christopher Oliver 1998-09-21 05:34:08 Re: [sferac@bo.nettuno.it: Re: [HACKERS] BUG: NOT boolfield kills backend]