Skip site navigation (1) Skip section navigation (2)

pgsql: Make DROP INDEX lock the parent table before locking the index.

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Make DROP INDEX lock the parent table before locking the index.
Date: 2008-06-15 16:29:05
Message-ID: 20080615162905.56951754595@cvs.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
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

Next:From: Andrew DunstanDate: 2008-06-15 21:46:03
Subject: pgsql: Add script to find .c and .h files that are missing CVS
Previous:From: Tom LaneDate: 2008-06-15 01:41:38
Subject: pgsql: Fix 64-bit problem in recent patch.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group