| From: | Pablo Funes <pablo(at)cs(dot)brandeis(dot)edu> |
|---|---|
| To: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | nonblocking lock? |
| Date: | 1999-04-12 21:19:37 |
| Message-ID: | 199904122119.RAA31982@mancha.cs.brandeis.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
Is it possible to do a nonblocking lock? That is,
I want several clients to execute,
begin
if table A is locked
then
go around doing stuff on other tables
else
lock A and do stuff on A
endif
the problem is, if I use normal lock, then
after one client has locked and is doing stuff on A
the other one will block and thus it won't be able
to go around doing stuff on other tables. Is it
possible to do a nonblocking lock that will just
fail if the table is locked already?
Thank you
Pablo Funes
Brandeis University
pablo(at)cs(dot)brandeis(dot)edu
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Lockhart | 1999-04-13 06:18:51 | Re: [INTERFACES] i broke my int8 =( |
| Previous Message | StOo | 1999-04-12 17:43:43 | i broke my int8 =( |