Stored Procedures - Mailing list pgsql-general

From Kent Anderson
Subject Stored Procedures
Date
Msg-id LPENJIOOLAIJBFKIBDKOIEFKEDAD.kenta@ezyield.com
Whole thread Raw
Responses Re: Stored Procedures  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-general
We are currently switching to stored procedures for a lot of our database activity. The question has come up about the transactional nature of the stored procedures.  I was wondering if stored procedures can have transactions in them or if you must start the transaction in your code and call the stored procedure from there to get the safety of a transaction?
 
Thanks
Kent Anderson
EZYield.com
407-629-0900
 
========================================
This electronic message transmission contains information from the Company that may be proprietary, confidential and/or privileged. The information is intended only for the use of the individual(s) or entity named above.  If you are not the intended recipient, be aware that any disclosure, copying or distribution or use of the contents of this information is prohibited.  If you have received this electronic transmission in error, please notify the sender immediately by replying to the address listed in the "From:" field.
 

pgsql-general by date:

Previous
From: "Michael Paesold"
Date:
Subject: Re: psql + autocommit
Next
From: Alvaro Herrera
Date:
Subject: Re: Stored Procedures