Transactions within plpgsql functions? - Mailing list pgsql-novice

From Celia McInnis
Subject Transactions within plpgsql functions?
Date
Msg-id 20050627144923.M96595@drmath.ca
Whole thread Raw
Responses Re: Transactions within plpgsql functions?  (Michael Fuhr <mike@fuhr.org>)
List pgsql-novice
Is there any way to have transactions work inside plpgsql procedures? So far
none of my attempts have worked. It's kind of frustrating to have to wait
days for results and especially so when the procedure terminates
unsuccessfully saying that I've done too many operations (more than 2**32
database operations in my setup).

Yes - I know that I could have procedures calling procedures to get what I
want, but this seems a little awkward.

Thanks for any assistance.
Celia McInnis

pgsql-novice by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: [despammed] copy from file and overwrite existing entries?
Next
From: Mattes Sarcander
Date:
Subject: Re: [despammed] copy from file and overwrite existing