SET TRANSACTION(7)               SQL Commands               SET TRANSACTION(7)

NAME
       SET TRANSACTION - <?><?><?><?><?><?><?><?><?>


SYNOPSIS
       SET TRANSACTION
           [ ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE } ] [ READ WRITE | READ ONLY ]
       SET SESSION CHARACTERISTICS AS TRANSACTION
           [ ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE } ] [ READ WRITE | READ ONLY ]


DESCRIPTION <?><?>
       SET TRANSACTION <?><?><?><?><?><?><?><?><?><?><?><?>
       <?><?><?><?><?><?><?><?><?><?><?><?> SET SESSION CHARACTERISTICS
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?> SET
       TRANSACTION <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

        <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>/<?><?><?><?><?><?><?>

        <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

       READ COMMITTED
               <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

       SERIALIZABLE
               <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

              Tip: <?><?>:
              <?><?><?><?>serializable<?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
              <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>


        <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?> (SELECT,
       INSERT, DELETE, UPDATE, FETCH, COPY)
       <?><?><?><?><?><?><?><?><?><?><?><?> <?><?> Chapter 12 ``Concurrency
       Control''
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

        <?><?><?><?><?><?><?><?><?><?><?><?>/<?><?><?><?><?><?><?>/<?><?><?><?><?><?><?><?><?>
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       SQL <?><?><?><?><?><?><?><?>INSERT<?> UPDATE<?>DELETE<?><?> COPY TO<?>
       <?><?><?><?> CREATE<?>ALTER<?><?> DROP <?><?><?>
       COMMENT<?>GRANT<?>REVOKE<?> TRUNCATE<?><?> EXPLAIN ANALYZE <?>EXECUTE
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

NOTES <?><?>
        <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

       SET default_transaction_isolation = 'value'

        <?><?><?><?><?><?><?><?><?><?><?> <?><?> Section 16.4 ``Run-time
       Configuration'' <?><?><?><?><?><?><?>

COMPATIBILITY <?><?><?>
        <?><?><?><?><?><?> SQL <?><?><?><?><?><?><?>SQL
       <?><?><?><?><?><?><?><?><?><?><?> SERIALIZABLE<?> <?> PostgreSQL
       <?><?><?><?><?><?><?><?><?> READ
       COMMITED<?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?> PostgreSQL
       <?><?><?><?><?><?><?><?><?> READ UNCOMMITTED <?> REPEATABLE READ<?>
       <?><?><?><?><?><?><?><?><?><?>SERIALIZABLE
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?> Chapter 12 ``Concurrency
       Control'' <?><?><?><?><?>

        <?> SQL
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       SQL<?>

<?><?>
       Postgresql <?><?><?><?> <?><?><?> <laser@pgsqldb.org>

<?>
       <?><?><?><?><?><?><?><?><?> man <?><?><?><?><?><?><?><?>
       <?><?> man <?><?><?><?><?><?>https://github.com/man-pages-zh/manpages-
       zh

SQL - Language Statements         2003-11-02                SET TRANSACTION(7)