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@candle.pha.pa.us]
> Sent: Thursday, September 05, 2002 3:48 PM
> To: nickf@ontko.com
> Cc: pgsql-admin@postgresql.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@candle.pha.pa.us               |  (610) 359-1001
>   +  If your life is a hard drive,     |  13 Roberts Road
>   +  Christ can be your backup.        |  Newtown Square,
> Pennsylvania 19073
>