pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Row Lock
2+ messages / 2 participants
[nested] [flat]

* Row Lock
@ 2007-11-22 18:31 PostgreSQL <malcus@terra.com.br>
  2007-11-22 19:12 ` Re: Row Lock Scott Marlowe <scott.marlowe@gmail.com>
  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 18:31 Row Lock PostgreSQL <malcus@terra.com.br>
@ 2007-11-22 19:12 ` Scott Marlowe <scott.marlowe@gmail.com>
  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