On Tue, Jun 19, 2012 at 8:50 AM, Edson Richter <edsonrich...@hotmail.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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
