Whether Transaction control statements like COMMIT/ROLLBACK/SAVEPOINT in POSTGRES 9.x

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sunilKUMAR549
    New Member
    • Apr 2012
    • 1

    Whether Transaction control statements like COMMIT/ROLLBACK/SAVEPOINT in POSTGRES 9.x

    I have a function which is taking long time to execute...i need commit the transcation chunk by chunk..is there a way to achieve that in postgres 9.x version..
  • r035198x
    MVP
    • Sep 2006
    • 13225

    #2
    Yes: http://www.postgresql.org/docs/9.1/s...sql-begin.html

    Comment

    Working...