Re: When I COMMIT....

From: <xhoster_at_gmail.com>
Date: 06 Nov 2006 17:02:53 GMT
Message-ID: <20061106120359.093$8v@newsreader.com>

"klabu" <noone_at_gmail_dot_com> wrote:
> Say if when i hit "Enter" on "commit ;", someone tripped on the power
> cord of the database box..

What is the exact timing here?

> Is it possible I'd lose 100% of that tranaction

Of course. That is what atomicity means, is it not?

> without ANY possibility
> of recovery.

Well, whoever doing the transaction should get a error telling them the transaction did not go through, so they should be able to recover it on their end, by waiting for the db to come back and re-doing the transaction.

Xho

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

Received on Mon Nov 06 2006 - 11:02:53 CST