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

From Tom Lane
Subject Re: Transaction aborts on syntax error.
Date
Msg-id 4532.1076707905@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:
>> which might not be for every statement.  Savepoints that you don't
>> actually need are going to be a fairly expensive overhead, AFAICS.

> Well with other db's per statement rollback is a no overhead feature, 
> so this is pg specific.

I very much doubt that.  We are not expending any disk I/O to do
rollback, which is not true in (say) Oracle.  I'm concerned about the
internal bookkeeping overhead.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Transaction aborts on syntax error.
Next
From: Joseph Tate
Date:
Subject: Re: pg_restore problems and suggested resolution