Re: [PL/pgSQL] Commit every N rows. Is it possible ?

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