Re: Rename Index - Deadlock

On Tue, Mar 16, 2010 at 3:45 AM, Thomas Kenner <thomas(dot)kenner(at)gmail(dot)com> wrote:
> Hi,
>
> Each day I'm recreating the index my_index of the table my_table. Therefore I
> create a new index my_index_new, drop the old index my_index, and rename the
> new index:
> ALTER INDEX my_index_new RENAME TO my_index;
>
> If an insert or select statement is run at the same time as the "ALTER INDEX
> ... RENAME TO" statement, it will end up in a deadlock.

A deadlock or just a lock? What version of pg? What exact error
messages do you get?