Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Question Unanswered: Triggers and COMMIT/ROLLBACK

    I need a trigger to be fired or a stored procedure to be called on an event of COMMIT or ROLLBACK.

    Non of ORACLE, SQL-SERVER, DB2 have this feature.

    Please let me know any alternative's

  2. #2
    Join Date
    Mar 2004


    Not sure what you are asking to be honest but i think a trigger wont be be fired until u commit a transaction.

    Would be helpfull if you would tell us what kind of transaction you are planning. I asume it has to do with insert, update or delete.

    In that case, its pretty straightforward.

    If its any help, all functions in postgresql ARE transactions by definition.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts