| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL <malcus(at)terra(dot)com(dot)br> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Row Lock |
| Date: | 2007-11-22 19:12:37 |
| Message-ID: | dcc563d10711221112m62d64ae9s3804c6da6c26d03b@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Nov 22, 2007 12:31 PM, PostgreSQL <malcus(at)terra(dot)com(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | LEROUX Ludovic | 2007-11-23 12:03:25 | problem with drop database or dropdb.exe on windows with postgresql 8.1 |
| Previous Message | PostgreSQL | 2007-11-22 18:31:20 | Row Lock |