locking of referenced table during constraint construction

From: Scott Shattuck <ss(at)technicalpursuit(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: locking of referenced table during constraint construction
Date: 2002-09-04 21:11:42
Message-ID: 1031173903.9343.1515.camel@idearat
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-09-04 21:14:13 Re: Bug in Makefile.shlib
Previous Message Olivier PRENANT 2002-09-04 20:43:15 Re: Bug in Makefile.shlib