On Wed, Nov 09, 2005 at 19:35:30 -0600, Tony Caduto <[EMAIL PROTECTED]> wrote: > <We found PostgreSQL a mature product, but in two things Firebird was > simply better than PostgreSQL: Two-Phase commit (ok, that is gone with > PG 8.1), but the second is a SNAPSHOT / REPEATABLE READ transaction > isolation. I can't live without that when it comes having a stable view > of data during one transaction, or did that change with 8.1? Is there > now a SNAPHOST / REPEATBLE READ transaction isolation level available as > well?> > > Just wondering what the PG take on this snapshot repeatable read stuff is.
http://candle.pha.pa.us/main/writings/pgsql/sgml/sql-set-transaction.html http://candle.pha.pa.us/main/writings/pgsql/sgml/transaction-iso.html ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match