pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRow Lock
2+ messages / 2 participants
[nested] [flat]
* Row Lock
@ 2007-11-22 18:31 PostgreSQL <malcus@terra.com.br>
0 siblings, 1 reply; 2+ messages in thread
From: PostgreSQL @ 2007-11-22 18:31 UTC (permalink / raw)
To: pgsql-admin
I'm having a problem with some row locks where one user does the lock
and another user try to do the same, but of course, the second one will
be waiting the first user unlock it.
I would like to know if there is a way to discover if that row is locked
before I try to do the lock.
I have been researching something like ROWID but I couldn't find
anything useful.
Thank's
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Row Lock
@ 2007-11-22 19:12 Scott Marlowe <scott.marlowe@gmail.com>
parent: PostgreSQL <malcus@terra.com.br>
0 siblings, 0 replies; 2+ messages in thread
From: Scott Marlowe @ 2007-11-22 19:12 UTC (permalink / raw)
To: PostgreSQL <malcus@terra.com.br>; +Cc: pgsql-admin
On Nov 22, 2007 12:31 PM, PostgreSQL <malcus@terra.com.br> wrote:
> I'm having a problem with some row locks where one user does the lock
> and another user try to do the same, but of course, the second one will
> be waiting the first user unlock it.
>
> I would like to know if there is a way to discover if that row is locked
> before I try to do the lock.
>
> I have been researching something like ROWID but I couldn't find
> anything useful.
I believe you want the NOWAIT option on your select.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-11-22 19:12 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-11-22 18:31 Row Lock PostgreSQL <malcus@terra.com.br>
2007-11-22 19:12 ` Scott Marlowe <scott.marlowe@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox