[SQL] help

2001-04-07 Thread Loïc Bourgeois
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

Re: [SQL] please help

2001-04-06 Thread Loïc Bourgeois
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

[SQL] please help

2001-04-05 Thread Loïc Bourgeois
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

[SQL] SELECT ... FOR UPDATE

2001-04-05 Thread Loïc Bourgeois
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