----- 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
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
