Rechercher une page de manuel

Chercher une autre page de manuel:

begin

Langue: en

Version: 2010-07-20 (ubuntu - 25/10/10)

Autres sections - même nom

Section: 7 (Divers)

NAME

BEGIN - start a transaction block

SYNOPSIS

 BEGIN [ WORK | TRANSACTION ] [ transaction_mode [, ...] ]
 
 where transaction_mode is one of:
 
     ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }
     READ WRITE | READ ONLY
 
 

DESCRIPTION

BEGIN initiates a transaction block, that is, all statements after a BEGIN command will be executed in a single transaction until an explicit COMMIT [commit(7)] or ROLLBACK [rollback(7)] is given. By default (without BEGIN), PostgreSQL executes transactions in ``autocommit'' mode, that is, each statement is executed in its own transaction and a commit is implicitly performed at the end of the statement (if execution was successful, otherwise a rollback is done).

Statements are executed more quickly in a transaction block, because transaction start/commit requires significant CPU and disk activity. Execution of multiple statements inside a transaction is also useful to ensure consistency when making several related changes: other sessions will be unable to see the intermediate states wherein not all the related updates have been done.

If the isolation level or read/write mode is specified, the new transaction has those characteristics, as if SET TRANSACTION [set_transaction(7)] was executed.

PARAMETERS

WORK
TRANSACTION
Optional key words. They have no effect.

Refer to SET TRANSACTION [set_transaction(7)] for information on the meaning of the other parameters to this statement.

NOTES

START TRANSACTION [start_transaction(7)] has the same functionality as BEGIN.

Use COMMIT [commit(7)] or ROLLBACK [rollback(7)] to terminate a transaction block.

Issuing BEGIN when already inside a transaction block will provoke a warning message. The state of the transaction is not affected. To nest transactions within a transaction block, use savepoints (see SAVEPOINT [savepoint(7)]).

For reasons of backwards compatibility, the commas between successive transaction_modes can be omitted.

EXAMPLES

To begin a transaction block:

 BEGIN;
 
 

COMPATIBILITY

BEGIN is a PostgreSQL language extension. It is equivalent to the SQL-standard command START TRANSACTION [start_transaction(7)], whose reference page contains additional compatibility information.

Incidentally, the BEGIN key word is used for a different purpose in embedded SQL. You are advised to be careful about the transaction semantics when porting database applications.

SEE ALSO

COMMIT [commit(7)], ROLLBACK [rollback(7)], START TRANSACTION [start_transaction(7)], SAVEPOINT [savepoint(7)]
* kiorky bonne nuit et hereux cauchamrs a certains de #debian-ff
-!- kiorky was kicked from #debian-fr by jb [c'est cela, oui]
-!- kiorky [~kiorky@lxxx-1-172.n.club-internet.fr] has joined #debian-fr
< ptitlouis> c'est l'assemblee générale des op ou quoi ? :)
< arachne> hahaha !
-!- kiorky was kicked from #debian-fr by jb [baballe ? Mag ?]
-!- kiorky [~kiorky@lxxx-1-172.n.club-internet.fr] has joined #debian-fr
-!- mode/#debian-fr [+o Magnum3] by ChanServ
-!- kiorky was kicked from #debian-fr by Magnum3 [baballe !!!]
< arachne> jb 15 - 0 Magnum3
-!- kiorky [~kiorky@lxxx-1-172.n.club-internet.fr] has joined #debian-fr
-!- kiorky was kicked from #debian-fr by nou [engagement !]
-!- kiorky [~kiorky@lxxx-1-172.n.club-internet.fr] has joined #debian-fr
-!- kiorky was kicked from #debian-fr by Magnum3 [paf !]
-!- kiorky [~kiorky@lxxx-1-172.n.club-internet.fr] has joined #debian-fr
< Subdino> rofl
< bernard> il se passe quoi là?
< sekhmetal> chut :)
-!- kiorky was kicked from #debian-fr by jb [reprise]
-!- kiorky [~kiorky@lxxx-1-172.n.club-internet.fr] has joined #debian-fr
-!- kiorky was kicked from #debian-fr by Magnum3 [passe à nou]
-!- mode/#debian-fr [+o ptitlouis] by ChanServ
-!- kiorky [~kiorky@lxxx-1-172.n.club-internet.fr] has joined #debian-fr
-!- kiorky was kicked from #debian-fr by ptitlouis [ptitlouis]
< teclo> ding ding
-!- kiorky [~kiorky@lxxx-1-172.n.club-internet.fr] has joined #debian-fr
-!- kiorky was kicked from #debian-fr by Magnum3 [POUF]
-!- kiorky [~kiorky@lxxx-1-172.n.club-internet.fr] has joined #debian-fr
-!- kiorky was kicked from #debian-fr by ptitlouis [dehors]
<@ptitlouis> :)
-!- kiorky [~kiorky@lxxx-1-172.n.club-internet.fr] has joined #debian-fr
-!- kiorky was kicked from #debian-fr by jb [*schbonk*]
< teclo> Heu, l'auto-rejoin, c'est bon pour les utilisateur mIRC
-!- kiorky [~kiorky@lxxx-1-172.n.club-internet.fr] has joined #debian-fr
-!- kiorky was kicked from #debian-fr by Magnum3 [ça rebondit bien hein ?]
-!- kiorky [~kiorky@lxxx-1-172.n.club-internet.fr] has joined #debian-fr
-!- kiorky was kicked from #debian-fr by ptitlouis [pfffffff]
< crevette> vous arretere de jouer au jokari tout seul
< sekhmetal> bon, elle va crever cette balle si ça continue
-!- kiorky [~kiorky@lxxx-1-172.n.club-internet.fr] has joined #debian-fr
-!- kiorky was kicked from #debian-fr by jb [*schbonk* *schbonk*]
< crevette> je veux jouer aussi au jokari kick
-!- crevette was kicked from #debian-fr by nou [pas de prb ! :)]
-- @ops in "Roland Garros" --
#debian-fr