Re: Is it possible 'Rollback' and 'Commit' Transactions in postgre functions - Mailing list pgsql-admin

From tamir@brobus.net (Tamir Halperin)
Subject Re: Is it possible 'Rollback' and 'Commit' Transactions in postgre functions
Date
Msg-id 8b1ea607.0209130241.1590f915@posting.google.com
Whole thread Raw
In response to Is it possible 'Rollback' and 'Commit' Transactions in postgre functions  ("shreedhar" <shreedhar@lucidindia.net>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: info
Date:
Subject: -i option
Next
From: Michael Zouroudis
Date:
Subject: on delete cascade problems