At 05:45 PM 11/22/2004, Chad Z. Hower wrote:

>1) Reads. For reads, I don't want them to see anything that has been changed
>since the transaction begun - that is they should see a snapshot as the db
>was when they started their Tx. If possible an erorr should be thrown if I
>attempt to do any writes (inserts or updates) in this type of transaction.

The tpb options are tpb_concurrency, tpb_read.

set transaction read only snapshot

>2) Updates. Updates should be like reads, but allow me to write. Updates
>should give me an error if I update a row that someone else updated since I
>started my transaction.

tpb_concurrency, tpb_write

set transaction snapshot