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:

    savepoint

    
    
    
    

    SYNOPSIS

           SAVEPOINT savepoint_name
    
    
    

    DESCRIPTION

           SAVEPOINT establishes a new savepoint within the current transaction.
    
           A savepoint is a special mark inside a transaction that allows all com-
           mands that are executed after it was established  to  be  rolled  back,
           restoring the transaction state to what it was at the time of the save-
           point.
    
    
    

    PARAMETERS

           savepoint_name
                  The name to give to the new savepoint.
    
    
    

    NOTES

           Use ROLLBACK TO SAVEPOINT [rollback_to_savepoint(7)] to rollback  to  a
           savepoint.  Use  RELEASE  SAVEPOINT [release_savepoint(7)] to destroy a
           savepoint, keeping the effects of commands executed after it was estab-
           lished.
    
           Savepoints  can  only  be  established when inside a transaction block.
           There can be multiple savepoints defined within a transaction.
    
    
    

    EXAMPLES

           To establish a savepoint and later undo the  effects  of  all  commands
           executed after it was established:
    
           BEGIN;
               INSERT INTO table1 VALUES (1);
               SAVEPOINT my_savepoint;
               INSERT INTO table1 VALUES (2);
               ROLLBACK TO SAVEPOINT my_savepoint;
               INSERT INTO table1 VALUES (3);
           COMMIT;
    
           The above transaction will insert the values 1 and 3, but not 2.
    
           To establish and later destroy a savepoint:
    
           BEGIN;
               INSERT INTO table1 VALUES (3);
               SAVEPOINT my_savepoint;
               INSERT INTO table1 VALUES (4);
               RELEASE SAVEPOINT my_savepoint;
           COMMIT;
    
           The above transaction will insert both 3 and 4.
    
    
    

    COMPATIBILITY

    
    

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

    
    
  • MORE RESOURCE


  • Linux

    The Distributions





    Linux

    The Software





    Linux

    The News



  • MARKETING






  • Toll Free

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