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".