Re: [HACKERS] SERIAL + PRIMARY KEY = redundant indexes - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: [HACKERS] SERIAL + PRIMARY KEY = redundant indexes
Date
Msg-id 37384F76.12341725@alumni.caltech.edu
Whole thread Raw
In response to SERIAL + PRIMARY KEY = redundant indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> regression=> create table t2 ( f1 serial, primary key (f1) );
> NOTICE:  CREATE TABLE will create implicit sequence t2_f1_seq for SERIAL column t2.f1
> NOTICE:  CREATE TABLE/UNIQUE will create implicit index t2_f1_key for table t2
> NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index t2_pkey for table t2
> CREATE
> And, indeed, it's made two separate indexes on t2's f1 field.  This is
> a bug, no?

Si. I'll look at it.
                        - Tom

-- 
Thomas Lockhart                lockhart@alumni.caltech.edu
South Pasadena, California


pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: [HACKERS] problem compiling 6.5 cvs (Linux, gcc 2.7.2, egcs 1.12)
Next
From: "Oliver Elphick"
Date:
Subject: Re: [HACKERS] Re: [SQL] plpgsql error