detecting locks

From: jim(at)reptiles(dot)org (Jim Mercer)
To: pgsql-general(at)postgresql(dot)org
Subject: detecting locks
Date: 1999-05-17 16:08:20
Message-ID: m10jPwC-00080dC@mailbox.reptiles.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


i have a number of processes which deal with the same table.

i've run into locking contention.

is there a way for me to tell if there are connections waiting on a share
or exclusive lock?

i'm using libpq and C.

--
[ Jim Mercer Reptilian Research jim(at)reptiles(dot)org +1 416 410-5633 ]
[ The telephone, for those of you who have forgotten, was a commonly used ]
[ communications technology in the days before electronic mail. ]
[ They're still easy to find in most large cities. -- Nathaniel Borenstein ]

Browse pgsql-general by date

  From Date Subject
Next Message Augusto Cardoso 1999-05-17 20:42:30 [Q] Can't generate C prog.with ecpg ------- Help please!
Previous Message selkovjr.mcs.anl.gov 1999-05-17 16:00:00 Re: [GENERAL] Trying to make functions in 'C'