Postgres Pro
Downloads
Home   >   mailing lists

question: foreign key constraints and AccessExclusive locks - Mailing list pgsql-hackers

From Jon Nelson
Subject question: foreign key constraints and AccessExclusive locks
Date
Msg-id CAKuK5J0SY-oM0syve0eGggoxDvx6f9+4m9hYg6JpPQ7C2Bm0XQ@mail.gmail.com
Whole thread Raw
Responses Re: question: foreign key constraints and AccessExclusive locks
List pgsql-hackers
Tree view 
When adding a foreign key constraint on tableA which references
tableB, why is an AccessExclusive lock on tableB necessary? Wouldn't a
lock that prevents writes be sufficient, or does PostgreSQL have to
modify *both* tables in some fashion? I'm using PostgreSQL 8.4 on
Linux.

-- 
Jon

pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: too much pgbench init output
Next
From: Tomas Vondra
Date:
Subject: Re: too much pgbench init output