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 <tgl@xxxxxxxxxxxxx> 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
