The following bug has been logged on the website: Bug reference: 6734 Logged by: Daniele Varrazzo Email address: daniele.varra...@gmail.com PostgreSQL version: 9.1.4 Operating system: Linux Description:
Weird, isn't it? Test case below. 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; -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
