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

Responses

• Re: question: foreign key constraints and AccessExclusive locks at 2013-01-06 10:14:18 from Simon Riggs

pgsql-hackers by date

Next:	From: Tomas Vondra	Date: 2013-01-06 03:13:12
	Subject: Re: too much pgbench init output
Previous:	From: Tatsuo Ishii	Date: 2013-01-06 02:03:18
	Subject: Re: too much pgbench init output