Hi, I'm using Django with Postgres 8.3.9 on CentOS Linux. I'm trying to figure out why locking isn't working as I'm expecting. I have a an operation wrapped in a transaction where I explicitely grab an exclusive lock on my table. When another process concurrently runs to do the same, it should block on attempting to acquire the exclusive lock, no? That is not what I am seeing. I see two processes both doing this 2010-06-16 12:14:31.909608500 LOG: connection received: host=[local] 2010-06-16 12:14:31.909748500 DEBUG: forked new backend, pid=30726 socket=6 2010-06-16 12:14:31.909784500 LOG: connection authorized: user=tugdbuser database=tugd b 2010-06-16 12:14:31.911516500 LOG: statement: SET DATESTYLE TO 'ISO' 2010-06-16 12:14:31.911630500 LOG: statement: SHOW client_encoding 2010-06-16 12:14:31.911768500 LOG: statement: SHOW default_transaction_isolation 2010-06-16 12:14:31.911849500 LOG: statement: SET client_encoding = 'UTF8' 2010-06-16 12:14:31.911972500 LOG: statement: BEGIN; SET TRANSACTION ISOLATION LEVEL R EAD COMMITTED 2010-06-16 12:14:31.912028500 LOG: statement: SET TIME ZONE E'America/New_York' 2010-06-16 12:14:31.912373500 LOG: statement: SELECT version() ...skipping... 2010-06-16 12:14:31.913008500 LOG: statement: LOCK TABLE instances IN ROW EXCLUSIVE MODE The first lock does not seem to prevent the second from completing. Am I misunderstanding how locks work in postgres? Thanks, Mike -- Michael P. Soulier <michael_soulier@xxxxxxxxx>, 613-592-2122 x2522 "Any intelligent fool can make things bigger and more complex... It takes a touch of genius - and a lot of courage to move in the opposite direction." --Albert Einstein
Attachment:
pgpYDROJlQ6D6.pgp
Description: PGP signature
