[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Problem while using commit..
From:       "Ian Harding" <iharding () tpchd ! org>
Date:       2005-04-30 14:19:39
Message-ID: s2733200.017 () MAIL ! TPCHD ! ORG
[Download RAW message or body]

I don't think you can do that.  While savepoints let you roll a
transaction back to a specified point, each sql statement is still
atomic and the only way to call a function is within a sql statement. 
 
>>> "Mahesh S." <smahesh@vision-tss.com> 4/30 3:08 am >>>  
Ian, 
 
  
 
I want to use a separate function to commit and rollback the 
transactions. 
 
If possible can I get a small example?  
 
  
 
Thanks and regards 
 
Mahesh 
 
  
 
  
 
  
 
 
 

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic