Re: Read only transaction problem

"BLGuy" <Guy.Wicks_at_gmail.com> wrote:

> However,
>
> CREATE TABLE copy_a SELECT * FROM table_a WHERE 1=0;
> CREATE TABLE copy_b SELECT * FROM table_b WHERE 1=0;
> to create two empty tables; then;
>
> BEGIN
> INSERT INTO copy_a SELECT * FROM table_a;
> INSERT INTO copy_b SELECT * FROM table_b;
> END;
> /
> COMMIT;
>
> would be consistent, as the anonymous block would consitute the
> "transaction" wrapper.

They would only be consistent if the block was run at the "serializable" isolation level. At the default isolation level, they would not be consistent.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB