locking of referenced table during constraint construction - Mailing list pgsql-hackers

From Scott Shattuck
Subject locking of referenced table during constraint construction
Date
Msg-id 1031173903.9343.1515.camel@idearat
Whole thread Raw
Responses Re: locking of referenced table during constraint construction  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-hackers
Hi,

Under what conditions would the following statement cause the USERS
table to lock out selects?


alter table my_coupons add constraint FK_mc_user_id FOREIGN KEY (mc_frn_user_id) REFERENCES users(user_ID);


ss

Scott Shattuck
Technical Pursuit Inc.





pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug in Makefile.shlib
Next
From: Stephan Szabo
Date:
Subject: Re: locking of referenced table during constraint construction