Postgres Pro
Downloads
Home   >   mailing lists

Thread: Is it possible 'Rollback' and 'Commit' Transactions in postgre functions

Is it possible 'Rollback' and 'Commit' Transactions in postgre functions

From
"shreedhar"
Date:
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

From
"Gaetano Mendola"
Date:
""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

From
tamir@brobus.net (Tamir Halperin)
Date:
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