Jeremiasz Miedzinski wrote:
> I'm digging into postgresql documentation but maybe I'm just not smart
> enough to understand the way which transactions are being processed into
> pgSQL. Is it possible to port above code to PL/pgSQL ?
All functions, including pl/pgsql functions take place within a
transaction. You cannot commit, but you can catch errors and roll back
to savepoints within a transaction.
If you want to have multiple transactions you will need to step outside
of the database.
It's not clear to me why your function does what it does anyway. I can't
see why you wouldn't just do this as standard queries.
--
Richard Huxton
Archonet Ltd