I read your document about the porting from Oracle to PgSql and I would
like to know if
you can say to me if there is an equivalent on an the option NOWAIT for
a request
SELECT ... FOR UPDATE (for Oracle) under PgSql.
This option don't wait a previus unlock and return the information like
the
Yes but the option NOWAIT say to the instruction
SELECT ... FOR UPDATE to not wait the unlock but to return the information
the lines can't be lock.
(Must retry late).
Peter Eisentraut wrote:
[EMAIL PROTECTED]">Loïc Bourgeois writes:
What is the equivalent of the oracle request: S
What is the equivalent of the oracle request: SELECT ... FOR UPDATE
NOWAIT, under PostGreSQL
Thanks a lot
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
I have to create a program to use the lastest version of PostgreSQL.
Many processes of this program must run in parallele.
In a table I have to select some specific row next insert a new row with
the same search carateristiques
and commit.
But between the select and the insert action none other