Re: Autocommit in Postgresql

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.

On 5/12/05, Olivier Thauvin <olivier.thauvin@aerov.jussieu.fr> wrote:
> Le Thursday 12 May 2005 09:31, Vitaly Belman a écrit :
> > I read that the "autocommit" setting doesn't exist in the new versions
> > of PostgreSQL. Is there another way to do it? I am using pgAdmin and
> > it is quite annoying to remember to open a transaction everytime.
>
> The autocommit setting is the default except you explicitly open a
> transaction.
>
>
>


--
 ICQ: 1912453
 AIM: VitalyB1984
 MSN: tmdagent@hotmail.com
 Yahoo!: VitalyBe