Re: undead index - Mailing list pgsql-general

From Jens Wilke
Subject Re: undead index
Date
Msg-id 201105061737.43264.jens.wilke@affinitas.de
Whole thread Raw
In response to Re: undead index  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: undead index
List pgsql-general
On Friday 06 May 2011 17:18:29 Tom Lane wrote:

Hi Tom,

> Possibly if
> you showed us the actual (not obfuscated) table declaration, associated
> constraint declarations, and resulting index definition, things would be
> clearer.

Thanks Tom, yes, the index is named
Indexes:
    "concurrently" btree (ulq_guid)
In the 8.4 cluster and 9.0.4's pg_dumpall dumps it as

CREATE INDEX concurrently ON foo USING btree (ulq_guid);

That's it.
But shouldn't pg_upgrade be able to handle this?

Regards, Jens

pgsql-general by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: Locale and UTF8 for template1 in 8.4.4
Next
From: Tom Lane
Date:
Subject: Re: undead index