The following bug has been logged on the website:
Bug reference: 6734
Logged by: Daniele Varrazzo
Email address: daniele.varrazzo@gmail.com
PostgreSQL version: 9.1.4
Operating system: Linux
Description:=20=20=20=20=20=20=20=20
Weird, isn't it? Test case below.=20
Dropping the comment, the create table command works as expected. The
command fails with an: "ERROR: relation "foo2_f1_idx" already exists".
begin;
CREATE TABLE foo
(
id serial primary key,
f1 integer NOT NULL
);
CREATE INDEX foo_idx1 ON foo (f1);
CREATE INDEX foo_idx2 ON foo (f1) WHERE id > 10;
COMMENT ON INDEX foo_idx2 IS 'whatever';
create table foo2 (like foo including all);
rollback;