| From: | tamir(at)brobus(dot)net (Tamir Halperin) |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Is it possible 'Rollback' and 'Commit' Transactions in postgre functions |
| Date: | 2002-09-13 10:41:47 |
| Message-ID: | 8b1ea607.0209130241.1590f915@posting.google.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
shreedhar(at)lucidindia(dot)net ("shreedhar") wrote in message news:<004201c25a41$6c692780$1201a8c0(at)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(at)lucidindia(dot)net
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adam Singer | 2002-09-13 10:57:57 | Re: ERROR: No such attribute or function 'oid' |
| Previous Message | Niclas Gustafsson | 2002-09-13 10:01:49 | LEFT JOINs takes forever...almost. |