Re: undead index

From: Jens Wilke <jens(dot)wilke(at)affinitas(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: undead index
Date: 2011-05-06 15:37:42
Message-ID: 201105061737.43264.jens.wilke@affinitas.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-05-06 15:50:22 Re: undead index
Previous Message Alan Hodgson 2011-05-06 15:19:36 Re: Locale and UTF8 for template1 in 8.4.4