[EMAIL PROTECTED] 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.
Is the SP executing a LOCK TABLE perchance? -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
