On Wed, Nov 09, 2005 at 19:35:30 -0600, Tony Caduto <tony_caduto@amsoftwaredesign.com> 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