Re: Feature discussion: Should syntax errors abort a transaction?

From: Darren Duncan <darren(at)darrenduncan(dot)net>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Feature discussion: Should syntax errors abort a transaction?
Date: 2012-06-19 22:06:01
Message-ID: 4FE0F7C9.10601@darrenduncan.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I like the current behavior. Having been pleasantly surprised that this is how
Pg operates, it is very helpful when I'm working on scripts or batches such as
for creating or populating schemas. If it dies part way through, I know I can
just fix the problem and rerun the whole thing, without having to first undo or
skip the earlier portions. Also, rollback for everything is much more
deterministic. -- Darren Duncan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dickson S. Guedes 2012-06-19 23:29:07 Re: pgstat wait timeout : permission denied
Previous Message Scott Marlowe 2012-06-19 21:58:47 Re: Feature discussion: Should syntax errors abort a transaction?