why did not suppert Rollback? postgresql

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • henryhcface
    New Member
    • Sep 2007
    • 15

    why did not suppert Rollback? postgresql

    hi ,all
    why did not suppert Rollback? postgresql

    update user_t where user_id=103 set user_name='henr y'

    but can not rollback . why , how to rollabck

    and do not suppert the

    delete from user_t where user_id=105 cascade;


    why did not suppert cascade ?

    thanks
  • rski
    Recognized Expert Contributor
    • Dec 2006
    • 700

    #2
    Originally posted by henryhcface
    hi ,all
    why did not suppert Rollback? postgresql

    update user_t where user_id=103 set user_name='henr y'

    but can not rollback . why , how to rollabck

    and do not suppert the

    delete from user_t where user_id=105 cascade;


    why did not suppert cascade ?

    thanks
    If you want to use rollback you should first start a transaction. Maybe just read a postgres manual at postgresql.org

    Comment

    Working...