Transactions within plpgsql functions?

From: "Celia McInnis" <celia(at)drmath(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Transactions within plpgsql functions?
Date: 2005-06-27 15:02:16
Message-ID: 20050627144923.M96595@drmath.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Mattes Sarcander 2005-06-27 15:45:19 Re: [despammed] copy from file and overwrite existing
Previous Message Andreas Kretschmer 2005-06-27 14:52:11 Re: [despammed] copy from file and overwrite existing entries?