Re: turn off auto-commit

Oh! I thought Waruna wanted to turn it off, but Björn wanted to know if it
could be controlled via psql.

Either way, both questions got answered, so we're set.

-Nick

> -----Original Message-----
> From: Bruce Momjian [mailto:pgman(at)candle(dot)pha(dot)pa(dot)us]
> Sent: Thursday, September 05, 2002 3:48 PM
> To: nickf(at)ontko(dot)com
> Cc: pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] turn off auto-commit
>
>
> Nick Fankhauser wrote:
> >
> > > Bruce Momjian wrote:
> > >
> > > Yes, autocommit appears in 7.3, due out in a few months.
> >
> > I'm confused.
> >
> > Isn't autocommit already there & on by default in psql currently?
>
> He wants to turn autocomit off:
>
> $ psql
> test=> UPDATE tab SET col = 1;
> test=> UPDATE tab2 SET col = 2;
> test=> COMMIT;
>
> With autocommit off, you basically start in a multi-statement
> transaction at the start and every time you commit.
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
> + If your life is a hard drive, | 13 Roberts Road
> + Christ can be your backup. | Newtown Square,
> Pennsylvania 19073
>