Re: No implicit index created when adding primary key with ALTER TABLE
| От | Thom Brown |
|---|---|
| Тема | Re: No implicit index created when adding primary key with ALTER TABLE |
| Дата | |
| Msg-id | BANLkTinzK2WRu6Ys1FVvH2t5Y8cYuW3WaQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | No implicit index created when adding primary key with ALTER TABLE (Stefan Keller <sfkeller@gmail.com>) |
| Ответы |
Re: No implicit index created when adding primary key with
ALTER TABLE
|
| Список | pgsql-general |
On 14 June 2011 06:39, Stefan Keller <sfkeller@gmail.com> wrote:
> 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".
Shouldn't you be looking for mytable2_pkey?
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
В списке pgsql-general по дате отправления: