Postgres Pro
Downloads
Home   >   mailing lists

pgsql: Make DROP INDEX lock the parent table before locking the index. - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Make DROP INDEX lock the parent table before locking the index.
Date
Msg-id 20080615162905.56951754595@cvs.postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
Log Message:
-----------
Make DROP INDEX lock the parent table before locking the index.  This behavior
is necessary to avoid deadlock against ordinary queries, but we'd broken it
with recent changes that made the DROP machinery lock the index before
arriving at index_drop.  Per intermittent buildfarm failures.

Modified Files:
--------------
    pgsql/src/backend/commands:
        tablecmds.c (r1.257 -> r1.258)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/tablecmds.c?r1=1.257&r2=1.258)

pgsql-committers by date:

Previous
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Fix 64-bit problem in recent patch.
Next
From: adunstan@postgresql.org (Andrew Dunstan)
Date:
Subject: pgsql: Add script to find .c and .h files that are missing CVS