Re: ACCESS EXCLUSIVE LOCK

You have a URL for where in the docs it says that? Sounds like it needs
to be updated to include TRUNCATE.

On Wed, Mar 01, 2006 at 03:55:26PM -0800, seth(dot)m(dot)green(at)gmail(dot)com wrote:
> This may be a newbie question, but according to the 7.4 docs, an ACCESS
> EXCLUSIVE lock is only acquired by the ALTER TABLE, DROP TABLE,
> REINDEX, CLUSTER, and VACUUM FULL commands.
>
> However, when viewing pg_locks during the execution of a stored
> procedure that does not perform any of the above commands, I see that
> the table it is working on is locked by ACCESS EXCLUSIVE.
>
> I have also tested that I can not perform a simple SELECT on the locked
> table while the SP is executing.
>
> Can anyone provide some insight?
>
> Thanks
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461