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.
Sorry, I forgot to mention: I think RowExclusiveLock or ExclusiveLock
would be sufficient instead.
In response to
pgsql-hackers by date
|Next:||From: Pavel Stehule||Date: 2005-03-22 06:32:10|
|Subject: Re: Proposal: OUT parameters for plpgsql|
|Previous:||From: Neil Conway||Date: 2005-03-22 05:56:31|
|Subject: locks in CREATE TRIGGER, ADD FK|