Home > mailing lists

Re: Alter index rename concurrently to - Mailing list pgsql-hackers

From	Victor Yegorov
Subject	Re: Alter index rename concurrently to
Date	July 17, 2018 01:40:33
Msg-id	CAGnEboiyFkmGbQFAvc+tViayyPnbJkWTd93kvmhhML+cQQ_OkA@mail.gmail.com Whole thread Raw
In response to	Alter index rename concurrently to (Andrey Klychkov <aaklychkov@mail.ru>)
Responses	Re[2]: Alter index rename concurrently to (Andrey Klychkov <aaklychkov@mail.ru>)
List	pgsql-hackers

Tree view

пн, 16 июл. 2018 г. в 21:58, Andrey Klychkov <aaklychkov@mail.ru>:

I made a patch to solve this issue (see the attachment).
It allows to avoid locks by a query like this:
“alter index <new_index> rename CONCURRENTLY to <old_index_name>”.

Please, have a look at previous discussions on the subject:
- 2012 https://www.postgresql.org/message-id/CAB7nPqTys6JUQDxUczbJb0BNW0kPrW8WdZuk11KaxQq6o98PJg@mail.gmail.com
- 2013 https://www.postgresql.org/message-id/CAB7nPqSTFkuc7dZxCDX4HOTU63YXHRroNv2aoUzyD-Zz_8Z_Zg@mail.gmail.com
- https://commitfest.postgresql.org/16/1276/

Victor Yegorov

pgsql-hackers by date:

From: Tomas Vondra
Date: 17 July 2018, 01:25:19
Subject: Re: [HACKERS] logical decoding of two-phase transactions

From: Alvaro Herrera
Date: 17 July 2018, 02:04:12
Subject: Re: Fix some error handling for read() and errno

Re: Alter index rename concurrently to - Mailing list pgsql-hackers

Previous

Next