On Tue, Jun 19, 2012 at 8:50 AM, Edson Richter <edsonrichter(at)hotmail(dot)com> wrote:
> There is also the case of dynamically generated sql statements based on user selection... being syntax or not, I would never 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.