START_TRANSACTION(7) - phpMan

START TRANSACTION(7)              PostgreSQL 14.15 Documentation             START TRANSACTION(7)

NAME
       START_TRANSACTION - start a transaction block

SYNOPSIS
       START TRANSACTION [ transaction_mode [, ...] ]

       where transaction_mode is one of:

           ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }
           READ WRITE | READ ONLY
           [ NOT ] DEFERRABLE

DESCRIPTION
       This command begins a new transaction block. If the isolation level, read/write mode, or
       deferrable mode is specified, the new transaction has those characteristics, as if SET
       TRANSACTION was executed. This is the same as the BEGIN command.

PARAMETERS
       Refer to SET TRANSACTION (SET_TRANSACTION(7)) for information on the meaning of the
       parameters to this statement.

COMPATIBILITY
       In the standard, it is not necessary to issue START TRANSACTION to start a transaction
       block: any SQL command implicitly begins a block.  PostgreSQL's behavior can be seen as
       implicitly issuing a COMMIT after each command that does not follow START TRANSACTION (or
       BEGIN), and it is therefore often called "autocommit". Other relational database systems
       might offer an autocommit feature as a convenience.

       The DEFERRABLE transaction_mode is a PostgreSQL language extension.

       The SQL standard requires commas between successive transaction_modes, but for historical
       reasons PostgreSQL allows the commas to be omitted.

       See also the compatibility section of SET TRANSACTION (SET_TRANSACTION(7)).

SEE ALSO
       BEGIN(7), COMMIT(7), ROLLBACK(7), SAVEPOINT(7), SET TRANSACTION (SET_TRANSACTION(7))

PostgreSQL 14.15                               2024                          START TRANSACTION(7)

Generated by $Id: phpMan.php,v 4.55 2007/09/05 04:42:51 chedong Exp $ Author: Che Dong
On Apache
Under GNU General Public License
2025-01-28 10:11 @3.133.108.155 CrawledBy Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)