↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / devel
Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3
Historical version. PostgreSQL 7.4 reached end of support in October 2010. See the current version for supported releases.
PostgreSQL 7.4.30 Documentation
Prev Fast Backward Fast Forward Next

START TRANSACTION

Name

START TRANSACTION -- start a transaction block

Synopsis

START TRANSACTION [ ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE } ] [ READ WRITE | READ ONLY ]

Description

This command begins a new transaction. If the isolation level or read/write mode is specified, the new transaction has those characteristics, as if SET TRANSACTION was executed. In all other respects, the behavior of this command is identical to the BEGIN command.

Parameters

See under SET TRANSACTION about the meaning of the parameters.

Compatibility

This command conforms to the SQL standard; but see also the compatibility section of SET TRANSACTION.

See Also

BEGIN, COMMIT, ROLLBACK, SET TRANSACTION
Prev Home Next
SHOW Up TRUNCATE

Report a documentation issue

Read the upstream documentation. For corrections, first check the current version.