Re: locks in CREATE TRIGGER, ADD FK

If you want to be my friend forever, then fix CLUSTER so that it uses 
sharerowexclusive as well :D

Chris

Neil Conway wrote:
> Neil Conway wrote:
> 
>> AndrewSN pointed out on IRC that ALTER TABLE ... ADD FOREIGN KEY and 
>> CREATE TRIGGER both acquire AccessExclusiveLocks on the table they are 
>> adding triggers to (the PK table, in the case of ALTER TABLE). Is this 
>> necessary? I don't see why we can't allow SELECT queries on the table 
>> to proceed while the trigger is being added.
> 
> 
> Attached is a patch that changes both to use ShareRowExclusiveLock, and 
> updates the documentation accordingly. I'll apply this later today, 
> barring any objections.