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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
