pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feed"no wait" option for locks
2+ messages / 2 participants
[nested] [flat]
* "no wait" option for locks
@ 2002-07-22 01:10 Daniel Stüwe <pgsql@aus.de>
0 siblings, 1 reply; 2+ messages in thread
From: Daniel Stüwe @ 2002-07-22 01:10 UTC (permalink / raw)
To: pgsql-sql
Hi...
anyone knows a workaround for Oracles "no wait" option in "SELECT ...
FOR UPDATE"?
I wrote a programm which runs twice. Both poll the pgsql database all 5
seconds and make an "SELECT ... FOR UPDATE" for the first row found.
After some work and commit the next row is processed. The second task
waits until the first hast commited, but it should detect the lock and
continue work with next row.
How can i detect this lock? Oracle returns with "no wait" option an sql
error code.
Any hints?
best regards
Daniel Stuewe
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: 'no wait' option for locks
@ 2002-07-22 03:26 mallah@trade-india.com
parent: Daniel Stüwe <pgsql@aus.de>
0 siblings, 0 replies; 2+ messages in thread
From: mallah@trade-india.com @ 2002-07-22 03:26 UTC (permalink / raw)
To: pgsql@aus.de; +Cc: pgsql-sql
Hi,
Why not the program create a lock file on start and delete it when finished.
regds
mallah.
> Hi...
>
> anyone knows a workaround for Oracles "no wait" option in "SELECT ...
> FOR UPDATE"?
>
> I wrote a programm which runs twice. Both poll the pgsql database all 5
> seconds and make an "SELECT ... FOR UPDATE" for the first row found.
> After some work and commit the next row is processed. The second task
> waits until the first hast commited, but it should detect the lock and
> continue work with next row.
>
> How can i detect this lock? Oracle returns with "no wait" option an sql
> error code.
>
> Any hints?
>
> best regards
> Daniel Stuewe
>
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 6: Have you searched our list
> archives?
>
> http://archives.postgresql.org
-----------------------------------------
Get your free web based email at trade-india.com.
"India's Leading B2B eMarketplace.!"
http://www.trade-india.com/
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-07-22 03:26 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-07-22 01:10 "no wait" option for locks Daniel Stüwe <pgsql@aus.de>
2002-07-22 03:26 ` Re: 'no wait' option for locks mallah@trade-india.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