Re: Stopping a transaction as soon as an error occurs

------=_Part_37430_11786057.1216603834996
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On Thu, Jul 17, 2008 at 7:36 PM, John DeSoi <desoi@[EMAIL PROTECTED]
> wrote:

> Put this at the stop of your file to make psql stop when an error
occurs:
>
> \set ON_ERROR_STOP 1
>


Thanks for this! This is basically what I need!


Ridvan

-- 
Bill Cosby  - "Advertising is the most fun you can have with your clothes
on."

------=_Part_37430_11786057.1216603834996
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div dir="ltr">On Thu, Jul 17, 2008 at 7:36 PM, John DeSoi &lt;<a
href="mailto:desoi@[EMAIL PROTECTED]
">desoi@[EMAIL PROTECTED]
>&gt; wrote:<br><div
class="gmail_quote"><blockquote class="gmail_quote" style="border-left:
1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left:
1ex;">

Put this at the stop of your file to make psql stop when an error
occurs:<br>
<br>
\set ON_ERROR_STOP 1<font color="#888888"><br>
</font></blockquote></div><br><br clear="all">Thanks for this! This is
basically what I need!<br><br><br>Ridvan<br><br>-- <br>Bill Cosby &nbsp;-
&quot;Advertising is the most fun you can have with your clothes on.&quot;
</div>

------=_Part_37430_11786057.1216603834996--