Ok. I'll keep looking at pg_locks. My original reason for reaching out to the list was over confusion as to when an EXCLUSIVE lock would be taken table level since the documentation says this should never happen except to some system catalogs. Is there something missing from the documentation? I feel like that would be a big clue. Here is what I'm referencing: http://www.postgresql.org/docs/8.2/interactive/explicit-locking.html
Thanks for your help! ---Marc On Nov 6, 2007 3:43 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > Well, if it's not a foreign key issue then I think that the UPDATE is > blocked waiting for some previous updater of the same row to commit. > If you poke around a bit harder in pg_locks you'll probably find that > the UPDATE is waiting to acquire ShareLock on someone else's transaction > ID, and that someone else is the culprit. > > regards, tom lane >