Re: Transaction aborts on syntax error. - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Transaction aborts on syntax error.
Date
Msg-id 2098.1076683808@sss.pgh.pa.us
Whole thread Raw
In response to Re: Transaction aborts on syntax error.  ("Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at>)
List pgsql-hackers
"Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at> writes:
> It seems to me, that leaving all this to the client (which implicitly
> inserts savepoints) can never be as efficient as a serverside feature.

I think this is an overly narrow view of "efficiency".  With client
control, the client can insert savepoints whereever it needs them,
which might not be for every statement.  Savepoints that you don't
actually need are going to be a fairly expensive overhead, AFAICS.

Also, in the V3 protocol, sending along extra BEGIN and COMMIT commands
doesn't have to cost you any extra network round trips.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Proposed Query Planner TODO items
Next
From: "Zeugswetter Andreas SB SD"
Date:
Subject: Re: Transaction aborts on syntax error.