Re: [HACKERS] SERIAL + PRIMARY KEY = redundant indexes

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] SERIAL + PRIMARY KEY = redundant indexes
Date: 1999-05-11 15:40:38
Message-ID: 37384F76.12341725@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)alumni(dot)caltech(dot)edu
South Pasadena, California

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Oleg Bartunov 1999-05-11 15:44:58 Re: [HACKERS] 6.5 cvs ERROR: copyObject: don't know how to copy 604
Previous Message Oleg Bartunov 1999-05-11 15:31:19 Re: [HACKERS] problem compiling 6.5 cvs (Linux, gcc 2.7.2, egcs 1.12)