Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id 631D91178C44
	for <pgsql-admin@postgresql.org>; Wed, 30 Nov 2011 04:27:30 -0400 (AST)
Received: from mail-iy0-f174.google.com ([209.85.210.174])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <ruralhunter@gmail.com>) id 1RVfVo-00033K-SO
	for pgsql-admin@postgresql.org; Wed, 30 Nov 2011 08:27:30 +0000
Received: by iage36 with SMTP id e36so420341iag.19
	for <pgsql-admin@postgresql.org>; Wed, 30 Nov 2011 00:27:15 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:subject:references
	:in-reply-to:content-type:content-transfer-encoding;
	bh=cmPDxwWTv3DFcpvF9irWWREeiTI5PReuo6N8avR2doY=;
	b=tzWE0uA9OZHbZQXg1BQzIgciXfOKnY56aeMGeFOR0uB1IKj430Q3tat6qrCc4HxReP
	N5OAsQKZGqTVHiGpK+giqUi+BZL738yIaZaO4gZRIPlCD6F6VgKu3HsS1NojaLBq7Q2F
	g8CF2ijoxCVZ0d1Ff1gNd3AP40WeINVl7Ob8I=
Received: by 10.50.89.227 with SMTP id br3mr1241181igb.14.1322641635811;
	Wed, 30 Nov 2011 00:27:15 -0800 (PST)
Received: from [192.168.1.6] ([116.231.51.178])
	by mx.google.com with ESMTPS id dm1sm2836317igb.6.2011.11.30.00.27.12
	(version=TLSv1/SSLv3 cipher=OTHER);
	Wed, 30 Nov 2011 00:27:14 -0800 (PST)
Message-ID: <4ED5E8D9.6080205@gmail.com>
Date: Wed, 30 Nov 2011 16:27:05 +0800
From: Rural Hunter <ruralhunter@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1;
 rv:8.0) Gecko/20111105 Thunderbird/8.0
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: transaction error handling
References: 
 <CAANiQEm92w70rapQhitV1qL0tpkNRo5qjpwo2fdg+iZ-AURMCg@mail.gmail.com>
	<28131.1322067903@sss.pgh.pa.us>
	<232B5217AD58584C87019E8933556D11036BDE58EB@redmx2.esri.com>
	<67D108EDFAD3C148A593E6ED7DCB4BBDEDDBAE@RADCONWIN2K8PDC.radcon.local>
In-Reply-To: 
 <67D108EDFAD3C148A593E6ED7DCB4BBDEDDBAE@RADCONWIN2K8PDC.radcon.local>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
X-Pg-Spam-Score: -2.7 (--)
X-Archive-Number: 201111/155
X-Sequence-Number: 38749

I have the same confusion...

于 2011/11/30 2:34, Rob Richardson 写道:
> Very naïve question here:  Why would you want to save the data from the first insert?
>
> I thought the purpose of a transaction was to make sure that all steps in the transaction executed, or none of them executed.  If Oracle saves half of the data  between the beginning and ending of the transaction, doesn't that defeat the purpose of the transaction?
>
> RobR
>