Re: Support for REINDEX CONCURRENTLY - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Support for REINDEX CONCURRENTLY
Date
Msg-id 50C65FCD.9030500@gmx.net
Whole thread Raw
In response to Re: Support for REINDEX CONCURRENTLY  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [SPAM?]: Re: Support for REINDEX CONCURRENTLY  (Simon Riggs <simon@2ndQuadrant.com>)
Re: Support for REINDEX CONCURRENTLY  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On 12/8/12 9:40 AM, Tom Lane wrote:
> I'm tempted to propose that REINDEX CONCURRENTLY simply not try to
> preserve the index name exactly.  Something like adding or removing
> trailing underscores would probably serve to generate a nonconflicting
> name that's not too unsightly.

If you think you can rename an index without an exclusive lock, then why
not rename it back to the original name when you're done?



pgsql-hackers by date:

Previous
From: Marti Raudsepp
Date:
Subject: [PATCH] pg_upgrade -o/-O regression in 9.2.2
Next
From: Simon Riggs
Date:
Subject: Re: [SPAM?]: Re: Support for REINDEX CONCURRENTLY