Re: Autocommit in Postgresql - Mailing list pgsql-novice

From Tom Lane
Subject Re: Autocommit in Postgresql
Date
Msg-id 572.1115908980@sss.pgh.pa.us
Whole thread Raw
In response to Re: Autocommit in Postgresql  (Vitaly Belman <vitalyb@gmail.com>)
List pgsql-novice
Vitaly Belman <vitalyb@gmail.com> writes:
> That's the problem... Is there a way to make it implicitly open a
> transaction? For example now in pgAdmin when I play with SQLs I have
> to do begin and rollback constant because whenever a query fails it
> refuses to do anything at all until I "rollback", and then of course I
> have to do "begin" again unless I want my queries to be real.

pgAdmin really should offer some kind of setting to help you with that.
Try asking the pgadmin gurus (I am not sure if any of them read this
list).

            regards, tom lane

pgsql-novice by date:

Previous
From: Vyom A
Date:
Subject: Starting the Database
Next
From: "Keith Worthington"
Date:
Subject: syncing a serial across tables