On Tue, Mar 16, 2010 at 3:45 AM, Thomas Kenner <thomas.ken...@gmail.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? -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql