On Mon, 2007-01-22 at 16:11 +0000, Gregory Stark wrote:
> "Simon Riggs" <simon@2ndquadrant.com> writes:
>
> > BEGIN;
> > stmt1;
> > stmt2; <-- error
> > stmt3;
> > COMMIT;
> >
> > results in stmt3 completing successfully even though stmt1 and stmt2 do
> > not == broken script.
>
> stmt1 would still be completed successfully.
OK, understood. ON_ERROR_ROLLBACK is what we need, for psql only.
-- Simon Riggs EnterpriseDB http://www.enterprisedb.com