Re: Stopping a transaction as soon as an error occurs

From: "Ridvan Lakas ng Bayan S(dot) Baluyos" <ridvan(at)baluyos(dot)net>
To: "John DeSoi" <desoi(at)pgedit(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Stopping a transaction as soon as an error occurs
Date: 2008-07-21 01:30:34
Message-ID: 7f4f9efa0807201830i13bbaeb0s337baa0b482718a5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Thu, Jul 17, 2008 at 7:36 PM, John DeSoi <desoi(at)pgedit(dot)com> 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."

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Bastiaan Olij 2008-07-21 06:48:22 Character set conversion
Previous Message Tom Lane 2008-07-18 05:14:42 Re: tracking down idle transactions in pg_locks