Hannes Dorbath <light(at)theendofthetunnel(dot)de> writes:
> This is a general thing I'd like to ask. If the creation of an index
> fails, why is it nevertheless there?
It's a rather ugly consequence of the fact that CREATE INDEX
CONCURRENTLY requires more than one transaction. If the later ones
fail, the invalid index is still there.
It'd be nice to clean that up sometime, but don't hold your breath.
regards, tom lane