START TRANSACTION

    Description

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

    SERIALIZABLE

    READ COMMITTED

    READ UNCOMMITTED

    READ WRITE

    READ ONLY

    Determines whether the transaction is read/write or read-only. Read/write is the default. When a transaction is read-only, the following SQL commands are disallowed: INSERT, UPDATE, DELETE, and COPY FROM if the table they would write to is not a temporary table; all CREATE, ALTER, and commands; GRANT, REVOKE, TRUNCATE; and EXPLAIN ANALYZE and EXECUTE if the command they would execute is among those listed.

    Examples

    To begin a transaction block:

    1. START TRANSACTION;

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

    See also the compatibility section of SET TRANSACTION.

    See Also

    BEGIN,

    Parent topic: SQL Command Reference