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.
The index contains a foreign key (don't know if this information is
important).
Is this a known issue?
Thanks, Thomas
--
Thomas Kenner