No implicit index created when adding primary key with ALTER TABLE

Поиск
Список
Период
Сортировка
От Stefan Keller
Тема No implicit index created when adding primary key with ALTER TABLE
Дата
Msg-id BANLkTi=RdZQGZ_hS2zb2M1ipzqCd34-miA@mail.gmail.com
обсуждение исходный текст
Ответы Re: No implicit index created when adding primary key with ALTER TABLE  (Thom Brown <thom@linux.com>)
Список 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".

В списке pgsql-general по дате отправления:

Предыдущее
От: Sim Zacks
Дата:
Сообщение: Re: determine client os
Следующее
От: Alban Hertroys
Дата:
Сообщение: Re: PGP encrypt/decrypt - Prereqistes