Postgres Pro
Downloads
Home   >   mailing lists

Re: Stopping a transaction as soon as an error occurs - Mailing list pgsql-novice

From Ridvan Lakas ng Bayan S. Baluyos
Subject Re: Stopping a transaction as soon as an error occurs
Date
Msg-id 7f4f9efa0807201830i13bbaeb0s337baa0b482718a5@mail.gmail.com
Whole thread Raw
In response to Re: Stopping a transaction as soon as an error occurs  (John DeSoi <desoi@pgedit.com>)
List pgsql-novice
Tree view
On Thu, Jul 17, 2008 at 7:36 PM, John DeSoi <desoi@pgedit.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."

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: tracking down idle transactions in pg_locks
Next
From: Bastiaan Olij
Date:
Subject: Character set conversion