Re: BUG #9148: generate invalid index (create index CONCURRENTLY ... )

tiyukeji(at)126(dot)com writes:
> canceling sql :
> CREATE INDEX CONCURRENTLY t_1_index
> ON t_1 USING btree
> (name);

> result:
> index t_1_index exist but size 0

This is expected when using CREATE INDEX CONCURRENTLY. See the
notes at
http://www.postgresql.org/docs/9.3/static/sql-createindex.html#SQL-CREATEINDEX-CONCURRENTLY
which say
"If a problem arises while scanning the table ... the CREATE INDEX command
will fail but leave behind an "invalid" index."

regards, tom lane