No implicit index created when adding primary key with ALTER TABLE

From: Stefan Keller <sfkeller(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: No implicit index created when adding primary key with ALTER TABLE
Date: 2011-06-14 06:39:31
Message-ID: BANLkTi=RdZQGZ_hS2zb2M1ipzqCd34-miA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

I observed some strange behaviour when adding a primary key with ALTER TABLE:

Given CREATE TABLE mytable1 (id serial, name text);
I filled it with data then did a
CREATE TABLE mytable2 AS SELECT * FROM mytable1;
ALTER TABLE mytable2 ADD PRIMARY KEY(id);

The last command reports - as usual - that implicitly an index on id
("mytable_pkey") was created - but it did not! It adds only a primary
key constraint on id. Can anybody explain this?

Yours, S.

P.S. I have installed "PostgreSQL 9.1alpha1, compiled by Visual C++
build 1500, 32-bit".

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2011-06-14 06:57:33 Re: PGP encrypt/decrypt - Prereqistes
Previous Message Sim Zacks 2011-06-14 06:35:52 Re: determine client os