Re: Feature discussion: Should syntax errors abort a transaction? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Feature discussion: Should syntax errors abort a transaction?
Date
Msg-id CAOR=d=11anPSC8CYN5m8Qr=LJaAmFfMsrGadY7f-HWniYnk9EA@mail.gmail.com
Whole thread Raw
In response to Re: Feature discussion: Should syntax errors abort a transaction?  (Edson Richter <edsonrichter@hotmail.com>)
Responses Re: Feature discussion: Should syntax errors abort a transaction?
List pgsql-general
On Tue, Jun 19, 2012 at 8:50 AM, Edson Richter <edsonrichter@hotmail.com> wrote:
> There is also the case of dynamically generated sql statements based on user selection... being syntax or not, I
wouldnever want half job done. Thia is the purpose of transactions: or all or nothing... 

This this this, and again, this.  Imagine:

begin;
insert into tableb selcet * from tableb;
truncate tableb;
commit;

What should happen when we get to the error on the second line?  Keep
going?  Boom, data gone because of a syntax error.

pgsql-general by date:

Previous
From: Paul Jones
Date:
Subject: Re: Fine-grained replication?
Next
From: Steve Crawford
Date:
Subject: Re: db server processes hanging around