On May 30, 2008, at 9:51 AM, Simon Riggs wrote:
> On Thu, 2008-05-29 at 19:18 -0500, Decibel! wrote:
>> Is there a reason that we can't add a trigger to a table while a
>> select is running? This is a serious pain when trying to setup
>> londiste or slony.
>
> This is constrained by locking.
>
> There are a subset of DDL commands that might be able to be performed
> with just an ExclusiveLock or ShareLock rather than an
> AccessExclusiveLock. Nobody has studied which sub-statements this  
> might
> apply to, but its do-able since CREATE INDEX already does this.

Is there a good way to determine this other than depending on  
knowledge of the source code?
-- 
Decibel!, aka Jim C. Nasby, Database Architect  decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828

In response to

• Re: Change lock requirements for adding a trigger at 2008-05-30 14:51:34 from Simon Riggs

Responses

• Re: Change lock requirements for adding a trigger at 2008-06-03 22:04:13 from Simon Riggs

pgsql-hackers by date

Next:	From: Decibel!	Date: 2008-06-03 21:57:58
	Subject: Re: proposal: Preference SQL
Previous:	From: Decibel!	Date: 2008-06-03 20:54:13
	Subject: Re: Hint Bits and Write I/O