Re: begin-end?

From: Doug McNaught <doug(at)wireboard(dot)com>
To: Joep deVocht <joep(at)masktools(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: begin-end?
Date: 2002-02-14 18:09:27
Message-ID: m3heokorzc.fsf@varsoon.denali.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Joep deVocht <joep(at)masktools(dot)com> writes:

> Hi,
>
> I've been reading the documentation but I need to be sure I
> understand correctly and am doing the right thing.
> Do I use "begin" and "end" if I want to lock the database
> so no user can do a transaction and mess up what I'm doing?
> (i.e. make the transactions between "begin" and "end" atomic to the
> other dbase users?)

Basically yes, but the transaction doesn't "lock" the database; the
other users just don't see the effects until you call "commit" (not
"end"). You can also call "rollback" instead of "commit" and it will
undo everything you did since the last "begin".

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863

In response to

  • begin-end? at 2002-02-14 18:01:29 from Joep deVocht

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Schreiber 2002-02-14 18:56:56 search engines
Previous Message Joep deVocht 2002-02-14 18:01:29 begin-end?