Re: read consistency question

Check into SET TRANSATION ISOLATION LEVEL SERIALIZABLE;

I *think* it will do what you are asking.

-JJ

"Chuck" <chuckh_at_softhome.net> wrote in message news:Xns93C182EF925C8chuckhsofthomenet_at_130.133.1.4...
> How can I set transaction-level read consistency in a read/write
> transaction?
>
> For example lets say session A is inserting and commiting rows every few
> seconds to table mytable. In session B I want to copy some rows from
> mytable to another table and then delete only those rows, ignoring those
> created by session A between after my insert began.
>
> insert into mytable2 (select * from mytable where col1 = 'x');
> 10 rows inserted
>
> delete from mytable where col1 = 'x';
> 12 rows deleted.
>
> I only want to delete the 10 rows that were processed by the insert. I
> don't want to delete the 2 rows that session A inserted after the insert
> began. I'm not looking for a workaround such as using an intermediate
> staging table. I'm looking for a way to make my session do transaction-
> level read consistency so it doesn't even see the 2 new rows inserted by
> session A after my insert began.
>
> TIA
Received on Wed Jul 23 2003 - 12:23:50 CDT