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

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "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 11:06:00
Message-ID: 4FE05D18.1070307@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 06/19/2012 02:20 PM, Tom Lane wrote:
> So you're suggesting that "SELECT 1/0;" should terminate a transaction,
> but "SELECT 1//0;" should not? How about "ROLBACK;"? It gets pretty
> squishy pretty fast when you try to decide which sorts of errors are
> more important than others.
>
When put that way, it seems blindingly obvious. You have a talent for
making a devastating point very succinctly.

--
Craig Ringer

POST Newspapers
276 Onslow Rd, Shenton Park
Ph: 08 9381 3088 Fax: 08 9388 2258
ABN: 50 008 917 717
http://www.postnewspapers.com.au/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message aasat 2012-06-19 13:05:42 SELECT INTO create new table, how to turn off this feature?
Previous Message Albe Laurenz 2012-06-19 10:34:02 Re: Fine-grained replication?