Re: Does psql use nested transactions? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Does psql use nested transactions?
Date
Msg-id 8608.1092768979@sss.pgh.pa.us
Whole thread Raw
In response to Re: Does psql use nested transactions?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Does psql use nested transactions?  (Honza Pazdziora <adelton@informatics.muni.cz>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Doing it only for interactive mode seems too error-prone to me (it works
> in psql, but not from my script).

You're missing the point: a script cannot safely work this way.  A human
typing at the terminal can notice that his command failed and react to
that, but a psql script cannot.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Does psql use nested transactions?
Next
From: "Marc G. Fournier"
Date:
Subject: 7.3.7 packaged ...