Received: from localhost (unknown [200.46.204.183])
	by developer.postgresql.org (Postfix) with ESMTP id 2A70A2E0044
	for <pgsql-admin-postgresql.org@developer.postgresql.org>;
	Wed, 28 May 2008 11:43:00 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 61270-08
	for <pgsql-admin-postgresql.org@developer.postgresql.org>;
	Wed, 28 May 2008 11:42:21 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from py-out-1112.google.com (py-out-1112.google.com
 [64.233.166.176])
	by developer.postgresql.org (Postfix) with ESMTP id 1F15D2E0059
	for <pgsql-admin@postgresql.org>; Wed, 28 May 2008 11:42:26 -0300 (ADT)
Received: by py-out-1112.google.com with SMTP id d37so2344566pye.29
	for <pgsql-admin@postgresql.org>; Wed, 28 May 2008 07:42:25 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type;
	bh=A0wFvZaSsR2nZe/EkYD8mnosmGOOBw3Ny1jgm2TZVjc=;
	b=SEpknCWPNbmLhUN4GsCnvDfFvJCIiLZrhU4oWBMK7raMGab00jdHyxcqLN1WPpGmzx1MiZc2EB2t1uC5qKSKx8H+xhvbZzIaClQUN/IX5qi6LXa8cF6zh2DdL2xMqthWjRx8BNGx/sFUXfZuQblNN5gkQiHdpkS/+KAMNaGY1DA=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=fuwz5ARCx/MuVAxFiUuAqjqrVZXsqaIq1IkGQU44DD1YY7eMuiqdGDPEf+X0duIDiJ2/7QOUYTsEzX7eEnkvoTymb7wFhEFLv0w79mA5IAClnT6UgyZTWzdbvfBUIQr+80mI18gYIVMJSbjPRsC3fMOhQVl26s8ELmevqFPmVG0=
Received: by 10.141.29.18 with SMTP id g18mr1237322rvj.162.1211985744977;
	Wed, 28 May 2008 07:42:24 -0700 (PDT)
Received: by 10.141.179.16 with HTTP; Wed, 28 May 2008 07:42:24 -0700 (PDT)
Message-ID: <fa5e02ea0805280742i66cccb3ep4393690f3ad83eb0@mail.gmail.com>
Date: Wed, 28 May 2008 11:42:24 -0300
From: "=?ISO-8859-1?Q?=C1lvaro_Guimar=E3es?=" <alvaroguimaraes@gmail.com>
To: pgsql-admin@postgresql.org
Subject: psql var ON_ERROR_ROLLBACK effect in pg_restore
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_752_29506519.1211985744948"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200805/230
X-Sequence-Number: 29314

------=_Part_752_29506519.1211985744948
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hello list,
I don't found anything about that in the archives, so...
I need to restore an binary backup that is generating errors.
The pg_restore utility is doing a rollback when he found errors.
Can i stop this?
With the psql utility i just set the ON_ERROR_ROLLBACK to get this effect.
Is that possible?
Sorry about my bad english.

--=20
=C1lvaro Guimar=E3es
Santa B=E1rbara D'Oeste - SP - Brazil

------=_Part_752_29506519.1211985744948
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hello list,<br>
I don&#39;t found anything about that in the archives, so...<br>
I need to restore an binary backup that is generating errors.<br>
The pg_restore utility is doing a rollback when he found errors.<br>
Can i stop this? <br>
With the psql utility i just set the ON_ERROR_ROLLBACK to get this effect.<=
br>
Is that possible?<br>
Sorry about my bad english.<br clear=3D"all"><br>-- <br>=C1lvaro Guimar=E3e=
s<br>Santa B=E1rbara D&#39;Oeste - SP - Brazil<br>

------=_Part_752_29506519.1211985744948--