Обсуждение: Is it possible 'Rollback' and 'Commit' Transactions in postgre functions
Hi All, Is it possible 'Rollback' and 'Commit' Transactions in postgre functions. If so where can i get a small example. Regards, Sreedhar Bhaskararaju 1,2nd Main Road, KottuGardens, Chennai - 600 085 Ph : 4475111 Email : shreedhar@lucidindia.net
Re: Is it possible 'Rollback' and 'Commit' Transactions in postgre functions
От
"Gaetano Mendola"
Дата:
""shreedhar"" <shreedhar@lucidindia.net> wrote in message news:004201c25a41$6c692780$1201a8c0@a4005... > Hi All, > > Is it possible 'Rollback' and 'Commit' Transactions in postgre functions. If > so where can i get a small example. Is not possible. Postgres don't manage innested transactions... not now... :-) Ciao Gaetano
Re: Is it possible 'Rollback' and 'Commit' Transactions in postgre functions
От
tamir@brobus.net (Tamir Halperin)
Дата:
shreedhar@lucidindia.net ("shreedhar") wrote in message news:<004201c25a41$6c692780$1201a8c0@a4005>... > Hi All, > > Is it possible 'Rollback' and 'Commit' Transactions in postgre functions. If > so where can i get a small example. > > Regards, > Sreedhar Bhaskararaju 1,2nd Main Road, KottuGardens, Chennai - 600 085 Ph : > 4475111 Email : shreedhar@lucidindia.net > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org The FAQ for PostgreSQL located at: http://www.us.postgresql.org/docs/faq-english.html talks about using Transactions as a way to tune for performance. The syntax includes "Begin" and "Commit". Furthermore, the online documentation available at: http://www.us.postgresql.org/users-lounge/docs/7.2/postgres/sql-begin.html clearly outlines the features and usage of transactions. Enjoy