Postgres Pro
Downloads
Home   >   mailing lists

Re: automatic restore point - Mailing list pgsql-hackers

From Justin Pryzby
Subject Re: automatic restore point
Date
Msg-id 20180626043713.GG20857@telsasoft.com
Whole thread Raw
In response to Re: automatic restore point  (Rui DeSousa <rui@crazybean.net>)
Responses Re: automatic restore point
List pgsql-hackers
Tree view 
On Tue, Jun 26, 2018 at 12:04:59AM -0400, Rui DeSousa wrote:
> Why not use auto commit off in the session or .psqlrc file or begin and then use rollback?  \set AUTOCOMMIT off
> 
> What would be nice is if a syntax error didn’t abort the transaction when auto commit is off — being a bad typist.

I think you'll get that behavior with ON_ERROR_ROLLBACK.

Justin

pgsql-hackers by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: Re: Problem while updating a foreign table pointing to apartitioned table on foreign server
Next
From: Rui DeSousa
Date:
Subject: Re: automatic restore point