Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 9600B63388C
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 31 Jul 2009 12:24:38 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 44842-09 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 31 Jul 2009 15:24:27 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.155])
	by mail.postgresql.org (Postfix) with ESMTP id A33A3632DC2
	for <pgsql-sql@postgresql.org>; Fri, 31 Jul 2009 12:24:27 -0300 (ADT)
Received: by fg-out-1718.google.com with SMTP id e12so620616fga.0
	for <pgsql-sql@postgresql.org>; Fri, 31 Jul 2009 08:24:26 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:date:message-id:subject
	:from:to:content-type;
	bh=BeV8Pg2y8M8KATUVTPyTNEPFv0T2DfXVWkJ1Hd5SIYg=;
	b=W+YcNPHkNdADtqoUZifl55ovuJ6l2MpVGiQyJ9EG2NtwQwoizWL5LEqXm4Ke6EPzy3
	HH7fzAAUFmYATNcC0+zADHNqBrdqXzeq5z9OVgS6FNA243QYNMdNzr4h8gfhW3Js7+om
	9jxJl57VvsfmkTh81+w2OvjGRlJUVHAr19gTk=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type;
	b=rDBJf8GU6K0QzjM4LnT00oVOV4hxzS/UnUpqHAqL5npKPVCmbHYrVA8DReAJAA8BfO
	wZVEn+L8D4DqE3eWbceDPCTgBBy9EUc8jWaWsjSFn9OVvg+XyAJoxBEAzh5vHvPSaTQP
	kM+ZqCMZVH1XlMJ32zggGJftEMde7tiN41jNo=
MIME-Version: 1.0
Received: by 10.86.54.7 with SMTP id c7mr937917fga.24.1249053866389; Fri, 31
	Jul 2009 08:24:26 -0700 (PDT)
Date: Fri, 31 Jul 2009 17:24:26 +0200
Message-ID: <a0eee4d40907310824h3fd0df14p75b633e38fd2d203@mail.gmail.com>
Subject: on error resume next
From: Jasmin Dizdarevic <jasmin.dizdarevic@gmail.com>
To: pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary=000e0cd29d0e02f11104700204da
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=-10 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200907/163
X-Sequence-Number: 32904

--000e0cd29d0e02f11104700204da
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

hi,

can i use savepoints to realize something like "on error resume next"?

i've got the following situation:

begin;
1. create view user001.accounts as select * from base.accounts;
2. grant select on user001.accounts to loginuser001;
commit;

begin;
 3. create view user002.accounts as select * from base.accounts;
4. grant select on user002.accounts to loginuser002;
commit;


my goal is to avoid execution stop, if one of the transactions fail.
let's say line 1 throws an error it should go further to line 3.

any ideas?

thank you.

jasmin

--000e0cd29d0e02f11104700204da
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div>hi, </div>
<div>=A0</div>
<div>can i use savepoints to realize something like &quot;on error resume n=
ext&quot;?</div>
<div>=A0</div>
<div>i&#39;ve got the following situation:</div>
<div>=A0</div>
<div>begin;</div>
<div>1. create view user001.accounts as select * from base.accounts;</div>
<div>2. grant select on user001.accounts to loginuser001;</div>
<div>commit;</div>
<div>=A0</div>
<div>begin;</div>
<div>
<div>3. create view user002.accounts as select * from base.accounts;</div>
<div>4. grant select on user002.accounts to loginuser002;</div>
<div>commit;</div>
<div>=A0</div>
<div>=A0</div>
<div>my goal is to avoid execution stop, if one of the transactions fail. <=
/div>
<div>let&#39;s say line 1 throws an error it should go further to line 3. <=
/div>
<div>=A0</div>
<div>any ideas?</div>
<div>=A0</div>
<div>thank you.</div>
<div>=A0</div>
<div>jasmin</div>
<div>=A0</div>
<div>=A0</div></div>

--000e0cd29d0e02f11104700204da--