Re: Index trouble with 8.3b4 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Index trouble with 8.3b4
Date
Msg-id 8709.1200257690@sss.pgh.pa.us
Whole thread Raw
In response to Re: Index trouble with 8.3b4  (Hannes Dorbath <light@theendofthetunnel.de>)
Responses Re: Index trouble with 8.3b4  (Hannes Dorbath <light@theendofthetunnel.de>)
List pgsql-hackers
Hannes Dorbath <light@theendofthetunnel.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


pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Postgresql Materialized views
Next
From: "Webb Sprague"
Date:
Subject: Re: Postgresql Materialized views