LinuxGuruz
  • Last 5 Forum Topics
    Replies
    Views
    Last post


The Web Only This Site
  • BOOKMARK

  • ADD TO FAVORITES

  • REFERENCES


  • MARC

    Mailing list ARChives
    - Search by -
     Subjects
     Authors
     Bodies





    FOLDOC

    Computing Dictionary




  • Text Link Ads






  • LINUX man pages
  • Linux Man Page Viewer


    The following form allows you to view linux man pages.

    Command:

    begin

    
    
    
    

    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 ''autocom-
           mit''  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  trans-
           action  has  those characteristics, as if SET TRANSACTION [set_transac-
           tion(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  trans-
           action 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)]).
    
           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)]
    
    
    

    SQL - Language Statements 2014-02-17 BEGIN(7)

    
    
  • MORE RESOURCE


  • Linux

    The Distributions





    Linux

    The Software





    Linux

    The News



  • MARKETING






  • Toll Free

webmaster@linuxguruz.com
Copyright © 1999 - 2016 by LinuxGuruz