Marin Dimitrov schrieb: > > ----- Original Message ----- > From: "Andre Schubert" > > > > > Can i do a select id from foo order by id desc limit 1 before the end of > > the transaction, > > does this return exactly the row i inserted for this transaction? > > > > only if u use SERIALIZABLE transaction isolation level - then the > transactions committed from other users *while* your transaction was in > progress are not visible
Oh thanks for your advice, i exactly use this transaction isolation level. > > in the default READ COMMITED level other committed transactions will > interfere with the "select id from foo order by id desc limit 1" you'll > issue before the end of your transaction > > take a look at "Read Committed and Serializable Isolation Levels" from > "PostgreSQL: Introduction and Concepts" > > hth, > > Marin > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
